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 vote324 views2 answers
Sql server add time to date
SQL
0 vote268 views2 answers
Delete the last item in a table sql
SQL
1 vote311 views2 answers
Rebuild index sql server
SQL
0 vote306 views1 answer
Sqlite3 get data from table c
SQL
0 vote302 views1 answer
Sql where time stamp is in between
SQL
1 vote334 views2 answers
Mysql switch case
SQL
0 vote326 views1 answer
Cannot create a JSON value from a string with CHARACTER SET 'binary'.
SQL
0 vote346 views1 answer
Sql with example
SQL
1 vote311 views1 answer
How to find median of a column sql
SQL
0 vote317 views1 answer
Sql list dates between two dates
SQL