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

1 vote329 views1 answer
Oracle repeat_interval 5 minutes
SQL
0 vote347 views2 answers
Create row number in sql
SQL
17 votes337 views4 answers
Sort by mysql
SQL
2 votes338 views1 answer
Oracle sql merge
SQL
25 votes357 views6 answers
Import database mysql command line
SQL
0 vote334 views1 answer
Why we have to set the password for my sql server
SQL
0 vote325 views1 answer
Sql server alter table add column datetime default current_timestamp
SQL
2 votes364 views1 answer
Alter table add column and foreign key mysql
SQL
0 vote319 views1 answer
Use where instead of join
SQL
0 vote324 views1 answer
Sql get guid
SQL