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

0 vote372 views1 answer
Hashpass
SQL
1 vote343 views1 answer
Oracle select row max date
SQL
0 vote334 views1 answer
Create table with float datatype in sql server
SQL
0 vote316 views1 answer
Postgresql update to unique
SQL
0 vote352 views2 answers
Many to many flask-sqlalchemy
SQL
0 vote328 views2 answers
Mysql regexp match word
SQL
5 votes294 views1 answer
Mongodb vs
SQL
9 votes340 views2 answers
Sql limit to 5 results
SQL
0 vote313 views1 answer
Soql more than today
SQL
0 vote314 views2 answers
2nd max salary query in sql
SQL