/SQL/Mysql copy table with new name

Mysql copy table with new name

Mysql copy table with new name

        
            
        
     CREATE TABLE IF NOT EXISTS new_table LIKE existing_table;

INSERT new_table
SELECT * FROM existing_table;

4

Source: mysqltutorial.org

Similar codes

0 vote186 views1 answer
Denormalise SQL command
SQL
1 vote185 views1 answer
Date_part mysql
SQL
2 votes202 views1 answer
How to show the whole table in sql
SQL
0 vote187 views1 answer
How to generate ids in sql
SQL
2 votes198 views1 answer
Grant revoke privileges to mysql username
SQL
8 votes222 views1 answer
Ltrim sql
SQL
0 vote187 views1 answer
Mysql_union
SQL
0 vote161 views1 answer
Hangfire clean script
SQL
1 vote205 views3 answers
Mysql on delete set null
SQL
10 votes188 views2 answers
Sql rtrim
SQL

Share