/SQL/Duplicating a MySQL table with all the data Command

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;

Similar codes

3 votes198 views1 answer
Mysql group_concat distinct
SQL
0 vote133 views1 answer
Add timestamp column to existing table ms sql server
SQL
10 votes172 views4 answers
Sql server pagination
SQL
0 vote126 views1 answer
Mysql add comment to column
SQL
0 vote189 views1 answer
Sql ssrs
SQL
0 vote143 views1 answer
Ms sql filter all sympbol
SQL
23 votes138 views4 answers
How to uninstall postgresql in ubuntu
SQL
1 vote175 views1 answer
Connect to mysql database ubuntu
SQL
0 vote132 views1 answer
Sql server select record with max id
SQL
0 vote147 views1 answer
USING THE NOT CONDITION IN SQL
SQL