Page Comparison

DROP query

The following query drops Doc_demo table from the database.

DROP TABLE Doc_demo

CREATE query:

The following query creates a table:

CREATE TABLE IF NOT EXISTS Doc_demo(ID INT,NAME STRING,AGE INT,ADDRESS STRING,SALARY INT) ROW FORMAT DELIMITED FIELDS TERMINATED BY ','

INSERT query:

The following query inserts the records of the members into the Doc_demo table:

INSERT INTO Doc_demo
VALUES (1, 'Ramesh', 32, 'Ahmedabad', 2000.00 ), (2, 'Khilan', 25, 'Delhi', 1500.00 ) ,(3, 'kaushik', 23, 'Kota', 2000.00 ), (4, 'Chaitali', 25, 'Mumbai', 6500.00 ),(5, 'Hardik', 27, 'Bhopal', 8500.00 ),
(6, 'Komal', 22, 'MP', 4500.00 )

SELECT query:

The following query retrieves all records from Doc_demo table:

Select * from Doc_demo