/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 votes118 views1 answer
Select nextval from sequence sql
SQL
0 vote118 views1 answer
Jdbc sql connection string
SQL
0 vote115 views1 answer
How to find all children of a record with only parent ID in sql
SQL
0 vote117 views1 answer
Sql server obtener nombre sin espacios en blanco
SQL
0 vote123 views2 answers
Mysql dump database tables only
SQL
0 vote157 views1 answer
Grouping by email domain mysql
SQL
0 vote128 views1 answer
Get relation data in mysql using query to excel
SQL
0 vote121 views1 answer
Value of sold product using having and group by in sql
SQL
0 vote118 views1 answer
Set a value by excuting stored procedure
SQL
0 vote115 views1 answer
Oracle query to see what scema i am working in
SQL