CREATE DATABASE database name ; // this is use to create the datbase SHOW DATBASES // THIS is use to show all the datbase use database datbase name /// is use to use the particular datbase CREATE TABLE persons(PersonsID int,LastName varchar(255),FirstName varchar(255),Address varchar(255),City varchar(255));// use to create the datbase SHOW TABLES // use to show all the tabels present in the database DROP TABLE table name /// is use to drop the tabel from the datbase TRUNCATE TABLE table_name; // THIS IS use to dletet the data inside the table INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country) VALUES ('Cardinal', 'Tom B. Erichsen', 'Skagen 21', 'Stavanger', '4006', 'Norway'); /// use to insert the data into the colum of the table SHOW FULL TABLES; // is use to show the content inside the table desc identity; // IS USE to show the structure of the table select * from identity; // is use to