/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

0 vote289 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
0 vote291 views1 answer
Sql server select top 2 of each group
SQL
6 votes352 views4 answers
Mysql get random row
SQL
15 votes292 views4 answers
Pl sql
SQL
0 vote588 views1 answer
How to connect .sql data set to powerbi
SQL
0 vote306 views1 answer
Ubuntu connect to mssql database
SQL
-1 vote330 views3 answers
PS5
SQL
0 vote320 views1 answer
Sql change primary key to composite key
SQL
4 votes300 views1 answer
Is there any command to change postgres password
SQL
0 vote371 views1 answer
Sqlite schema structure of a relational database
SQL