/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

1 vote153 views3 answers
Drop unique key constraint in sql server
SQL
0 vote142 views1 answer
How to install postgresql on wsl
SQL
1 vote145 views2 answers
Replace text in sql
SQL
1 vote209 views1 answer
Mysql stop password policy
SQL
0 vote130 views1 answer
Count the table indatabase
SQL
0 vote210 views1 answer
How do you insert boolean to postgresql
SQL
0 vote142 views1 answer
Oracle current timestamp
SQL
0 vote144 views1 answer
Top frequency in sql server
SQL
4 votes154 views3 answers
Mysql modify foreign key
SQL
0 vote184 views1 answer
Mysql extract day from date leading zero
SQL

Share