SQL # 1: CREATE DATABASE, TABLE AND INSERT RECORDS

Published: 09 June 2020
on channel: Business Intelligence Developer

--To create a new Database
CREATE DATABASE MyNewDB

--To alter Database name
USE master

ALTER DATABASE NEWDB
MODIFY NAME = Members

--To create a new table and insert records
USE MyNewDB

CREATE TABLE Members
(
ID VARCHAR(10) NOT NULL,
Full_Name VARCHAR(50) NOT NULL,
Age VARCHAR(3)
)

INSERT INTO Members (ID, Full_Name, Age)

VALUES ('A000001','Tony Starks','45'), ('A000002','Jimmy Small','32'), ('A000003','Melanie Brown','41')

--To select all records from Members table
USE MyNewDB

SELECT * FROM Members

On this page of the site you can watch the video online SQL # 1: CREATE DATABASE, TABLE AND INSERT RECORDS with a duration of hours minute second in good quality, which was uploaded by the user Business Intelligence Developer 09 June 2020, share the link with friends and acquaintances, this video has already been watched 64 times on youtube and it was liked by 6 viewers. Enjoy your viewing!

636