Table

Create Table

CREATE TABLE `student` (
    `id` INT,
    `name` CHAR(50),
    `email` VARCHAR(50)
);

CREATE TABLE IF NOT EXISTS `student` (
    `id` INT,
    `name` CHAR(50),
    `email` VARCHAR(50)
);

CREATE TABLE IF NOT EXISTS `teacher` (
    `id` INT,
    `name` CHAR(50),
    `email` VARCHAR(50)
);

Get the List of Table in the Selected Database

SHOW TABLES;
SHOW TABLES IN `database_name`;

Drop Table

DROP TABLE `teacher`;
DROP TABLE IF EXISTS `teacher`;

DROP TABLE `database_name`.`teacher`;
DROP TABLE IF EXISTS `database_name`.`teacher`;

DROP TABLE `teacher`, `student`;
DROP TABLE IF EXISTS `teacher`, `student`;

Create a Table from another Table

CREATE TABLE `teacher` LIKE `student`;
CREATE TABLE `teacher` LIKE `database_name`.`student`;

CREATE TABLE IF NOT EXISTS `teacher` LIKE `student`;

CREATE TABLE IF NOT EXISTS 
`teacher` LIKE `database_name`.`student`;

Get Table Description

DESCRIBE `teacher`;
DESCRIBE `database_name`.`teacher`;
DESCRIBE `teacher` `id`;
DESCRIBE `database_name`.`teacher` `id`;

DESC `teacher`;
DESC `database_name`.`teacher`;

EXPLAIN `teacher`;
EXPLAIN `database_name`.`teacher`;

SHOW FIELDS FROM `teacher`;
SHOW FIELDS FROM `database_name`.`teacher`;
SHOW COLUMNS FROM `student`;
SHOW COLUMNS FROM `database_name`.`teacher`;
SHOW COLUMNS FROM `student` FROM `database_name`;
SHOW CREATE TABLE `teacher`;

Alter Table

ALTER TABLE `student`
ADD `dob` DATE;

ALTER TABLE `student`
RENAME COLUMN  `dob` TO `date_of_birth`;

ALTER TABLE `student`
MODIFY COLUMN `date_of_birth` DATETIME;

ALTER TABLE `student`
DROP COLUMN `date_of_birth`;