A quick summary of the most popular MySQL queries.

create database [database_name];

create database school;

show databases;

show databases;

use [database_name];

use school;

create table [table_name](column_name_1 datatype(size), column_name_2 datatype(size),

….

column_name_n datatype(size)

);

create table student_details( Roll_no int(10), student_name VARCHAR(50), student_address VARCHAR(90), student_gender VARCHAR(10), student_marks int(10) );

show tables;

show tables;

describe [table_name];

OR

SHOW COLUMNS FROM [table_name];

describe student_details;

OR

SHOW COLUMNS FROM student_details

INSERT INTO [table_name] (column_name_1,column_name_2,…column_name_n) VALUES (value1,value2,….valuen);

OR

INSERT INTO [table_name] VALUES (value1,value2,….valuen);

INSERT INTO student_details( Roll_no, student_name, student_address, student_gender, student_marks) VALUES(01,”John Doe”, “New York”,”Male”,85),(02, “Recky”, “L.A”, “Female”,90), (03, “Alex John”,”London”,”Male”,20);

SELECT * FROM [table_name];

SELECT * FROM student_details;

SELECT [column_name] FROM [table_name];

OR

SELECT [column_name1],[column_name2] FROM [table_name];

SELECT student_name FROM student_details;

OR

SELECT student_name, student_marks FROM student_details;

UPDATE [table_name] SET column_name =new_value,  column_name2= new_value2 [WHERE condition]

UPDATE student_details SET student_marks=60 WHERE Roll_no=4;

ALTER TABLE [table_name] ADD [column_name] [datatype];

OR

ALTER TABLE [table_name]
DROP COLUMN [column_name];

ALTER TABLE student_details ADD student_age int(10);

OR

ALTER TABLE student_details DROP COLUMN student_age;

DELETE FROM [table_name] [WHERE condition];

DELETE FROM student_details WHERE student_marks=20;

TRUNCATE TABLE [table_name];

TRUNCATE TABLE student_details;

drop table [table_name];

drop table student_details;

drop database [database_name];

drop database student_details;