Copy a table structure and records to another new table
CREATE TABLE student2 SELECT * FROM student
CREATE TABLE student2 SELECT * FROM student WHERE class='Four'
Copy table structure only
create table t1 like student
Create table if not exists
CREATE TABLE IF NOT EXISTS student5 SELECT * FROM student WHERE class='Four'
DROP TABLE IF EXISTS `student5`
CREATE TABLE recipes_new LIKE production.recipes
INSERT recipes_new SELECT * FROM production.recipes