Answers for "mysql duplicate table"

SQL
4

mysql copy table with new name

CREATE TABLE IF NOT EXISTS new_table LIKE existing_table;

INSERT new_table
SELECT * FROM existing_table;
Posted by: Guest on September-09-2020
1

how to duplicate table in mysql

CREATE table `duplicat` LIKE `orginal`;
INSERT `duplicat` SELECT * FROM `orginal`;
Posted by: Guest on June-02-2021

Code answers related to "mysql duplicate table"

Code answers related to "SQL"

Browse Popular Code Answers by Language