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 vote373 views1 answer
Sql last 3 rows
SQL
0 vote350 views2 answers
Postgres another version
SQL
0 vote328 views1 answer
How to get inserted id in sql server
SQL
4 votes323 views1 answer
Mac install mysql
SQL
2 votes324 views2 answers
Function in sql
SQL
15 votes347 views6 answers
Psql
SQL
0 vote361 views1 answer
Sql getdate minus 1 day without time
SQL
1 vote376 views1 answer
Oracle compile schema
SQL
0 vote368 views1 answer
Select a row include list of array with join table SQL
SQL
0 vote357 views1 answer
Synapse sql table set pk
SQL