/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

22 votes354 views3 answers
Remove all records from table mysql
SQL
0 vote365 views1 answer
How to run mysql in git bash
SQL
2 votes390 views1 answer
Oracle Column Names of a table
SQL
0 vote352 views1 answer
Php select data from mysql database without column name
SQL
0 vote371 views1 answer
Capabilities of sql select statements
SQL
0 vote376 views1 answer
Mysql 3 months ago
SQL
0 vote335 views1 answer
Rabbitmq service not starting
SQL
0 vote343 views1 answer
How to install mysql without admin rights
SQL
0 vote329 views1 answer
Importerror no module named mysql.connector raspberry pi
SQL
0 vote381 views1 answer
Python sql last insertend
SQL