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

2 votes333 views1 answer
Mysql sysdate - 1 day
SQL
0 vote360 views1 answer
Gcloud sql list databases
SQL
2 votes328 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly. 11:04:35 PM [mysql] This may be due to a blocked port, missing dependencies,
SQL
8 votes349 views1 answer
My sql version
SQL
0 vote361 views1 answer
"/** MySQL database password */" ext:txt | ext:cfg | ext:env | ext:ini
SQL
0 vote344 views1 answer
Sql server alter table add column tinyint
SQL
-1 vote357 views2 answers
Import data from excel to sql server automatically
SQL
0 vote334 views1 answer
Sql reverse order of results
SQL
0 vote325 views2 answers
Sql join on wildcard
SQL
1 vote333 views1 answer
Continue in sql
SQL