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

4 votes277 views2 answers
DB::transaction
SQL
0 vote295 views1 answer
Longtext sql
SQL
1 vote297 views1 answer
Oracle turn off constraint
SQL
1 vote283 views1 answer
How to get mysql db size
SQL
0 vote274 views1 answer
Import mysql'
SQL
2 votes311 views1 answer
Q operator in plsql
SQL
0 vote309 views1 answer
Running mysql from bash sc
SQL
12 votes290 views5 answers
Sql merge
SQL
1 vote289 views1 answer
How to use a trigger to validate input data
SQL
0 vote287 views2 answers
Csv into data postgres
SQL