/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

7 votes198 views3 answers
Sql server reset auto increment
SQL
0 vote177 views1 answer
Mysql workbench primary key
SQL
11 votes190 views1 answer
Creating tables in sql with python
SQL
0 vote206 views1 answer
How to get number of months between 2 dates sql server
SQL
0 vote209 views1 answer
Remove mysql from centos 7
SQL
0 vote170 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote176 views2 answers
Android sqlite query join
SQL
10 votes181 views2 answers
Reset mysql root password mac
SQL
0 vote189 views1 answer
Liquibase update row
SQL
0 vote171 views1 answer
Sqlalchemy.exc.OperationalError:
SQL