SQL BASICS: First goto this folder Connectivity: -u username: root -p password: -h host:127.0.0.1 Password: just give enter bcoz there is no password Create database : Create database database_name; Use database; Create Table: Drop: used to delete both the structure and record drop table table_name; drop Table: Drop column: ALTER TABLE "table_name" DROP "column_name"; Before drop: After drop: Alter: to add a column to existing table -add to rename any existing column- rename to change datatype of any column or to modify its size. -modify to drop a column from the table. -drop Adding multiple colums Add Column with default value: ALTER TABLE table_name ADD ( column -name1 datatype1 DEFAULT some_value ); ...