Duplicating a MySQL table with all the data Command code example

Example: Duplicating a MySQL table with all the data Command

CREATE TABLE `new_table` (id INT(11) auto_increment primary key) SELECT old_table.name, old_table.group, old_table.floor, old_table.age from old_table;