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 vote239 views1 answer
Change filed order in mysql
SQL
0 vote214 views1 answer
Update set with join pl sql
SQL
0 vote247 views1 answer
What logs are available on RDS MySQL?
SQL
10 votes223 views5 answers
Between keyword in sql
SQL
0 vote200 views1 answer
How do i calculate someone's age based on a datetime type birthday?
SQL
10 votes215 views3 answers
Insert into auto increment mysql
SQL
2 votes244 views1 answer
Q operator in plsql
SQL
16 votes232 views4 answers
Find duplicates mysql
SQL
1 vote220 views1 answer
Postgresql datetrunc too slow
SQL
1 vote240 views1 answer
Oracle grant select on schema
SQL