• Create a database

CREATE DATABASE databasename;

  • Delete the database

DROP DATABASE databasename;

  • Create table

CREATE TABLE tablename (column1, column2, cloumn3);

  • Delete the table

DROP TABLE tablename;

  • Insert into table

INSERT INTO tablenaame(col1, col2,col3)

VALUES('21' 'AASIM' 'ALI') where id = 1;

  • View the data in table

SELECT *FROM Tablename;

  • View specific column from the table

SELECT COL1,COL2 FROM Tablename;

  • Update the table

UPDATE Tablename 

SET col1 = '12', col2 = 'aa'