Mysql how to set update or create

Mysql update set

CREATE TABLE copy LIKE original;

ALTER TABLE copy DISABLE KEYS;
SET unique_checks=0; SET foreign_key_checks=0; 

INSERT INTO copy SELECT * FROM original;

ALTER TABLE copy ENABLE KEYS;
SET unique_checks=1; SET foreign_key_checks=1;

-1

Source: stackoverflow.com

Similar codes

5 votes160 views1 answer
Oracle ora-00054 resource busy
SQL
0 vote132 views2 answers
Functions with parameters SQL
SQL
0 vote144 views2 answers
How to use aggregate functions in sql
SQL
1 vote151 views1 answer
Check if mysql is installed
SQL
0 vote140 views1 answer
Mysql join same table multiple times group by
SQL
2 votes138 views1 answer
Change primary key sql
SQL
10 votes177 views2 answers
Reset mysql root password mac
SQL
0 vote139 views1 answer
Oracle archivelog usage
SQL
3 votes139 views1 answer
Start mysql server by terminal in linux
SQL
0 vote142 views1 answer
How to add boolean column in postgresql
SQL