/* 003 - CREATE_TABLE_&_column and insert_data*/
-- syntax - CREATE TABLE table_name ( column_name datatype);
CREATE TABLE tOne (
id INT ,
name VARCHAR(50) ,
birth_date DATE,
phone VARCHAR(15),
gender VARCHAR(1)
);
-- another Example
CREATE TABLE product(
pid INT ,
pname VARCHAR(50) ,
pcompany VARCHAR(50),
price INT
);
-- insert_data
-- syntax - INSERT INTO table_name (column1, column2) VALUES (value1, value2);
INSERT INTO tOne ( id, name, birth_date, phone, gender)
VALUES ( 1,"Ram Kumar", "1990-07-15", "9977664422", "M" );
INSERT INTO tOne ( id, name, birth_date, phone, gender)
VALUES ( 2,"Meera Khan", "1991-02-10", "9988552211", "F" );
INSERT INTO tOne ( id, name, birth_date, phone, gender)
VALUES ( 1,"Anil Kapoor", "1993-10-05", "9484542414", "M" );
-- insert multiple data in one go */
INSERT INTO tOne ( id, name, birth_date, phone, gender)
VALUES
( 3,"Anil Kapoor", "1993-10-05", "9484542414", "M" ),
( 4,"Juhi Chawla", "1992-03-15", "9477884421", "F" ),
( 5,"John Abraham", "1992-02-07", "947584421", "M" );