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