/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 vote140 views1 answer
How to read the potentail error messages in ssis package
SQL
0 vote170 views1 answer
Sql alchemy escape ; in insert statement
SQL
0 vote116 views1 answer
How to print out column name differently in mysql
SQL
-2 votes214 views1 answer
How-to-remove-mysql-root-password
SQL
31 votes128 views3 answers
SQL Server change column data type
SQL
0 vote134 views1 answer
Mysql get date diff in months
SQL
14 votes131 views2 answers
Install mysqldump
SQL
0 vote121 views1 answer
Oracle sql developer closed connection
SQL
0 vote118 views1 answer
Openquery insert into linked server
SQL
0 vote116 views1 answer
User defined variables in sql
SQL