Create

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)
);

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`;