In MySql, copy the old table structure to the new table, and mysql copies the table structure

In MySql, copy the old table structure to the new table, and mysql copies the table structure

# Creating a student table

Create table student (age int, name varchar (32) engine myisam charset utf8;
Insert into student values (18, 'xiaobai ');

# Create a instructor table with the same structure as the student table
Create table teacher like student;

# Write the data in the student table into the instructor table
Insert into teacher select * from student;

# Create a parent table with the same structure as the student table
Create table parent select * from student;

# Create a school table with the same structure as the student table
Create table school select * from student where 1 = 2; # That is, the condition is not true.