/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 vote338 views1 answer
Limiting query result using where in sql
SQL
0 vote358 views1 answer
How to list function in psql
SQL
0 vote355 views1 answer
Mssql + bit + in python orm
SQL
0 vote284 views1 answer
Sql table to store status
SQL
-1 vote353 views8 answers
Create Trigger in phpMyAdmin
SQL
4 votes345 views1 answer
Oracle session date format
SQL
0 vote369 views1 answer
Creating sqeuence in oracle database
SQL
0 vote339 views1 answer
Group_concat only returns one row
SQL
0 vote319 views1 answer
Sql query for getting data with join and count
SQL
15 votes348 views5 answers
Show tables in oracle
SQL

Share