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 vote117 views1 answer
Remove from table where
SQL
0 vote132 views1 answer
6)selects only the DISTINCT values from the "side" column in the "Reserves" table
SQL
0 vote111 views1 answer
Mysql into outfile with headers
SQL
0 vote122 views1 answer
C# execute transact sql
SQL
0 vote119 views1 answer
Connect to nginx server mysql remotly
SQL
0 vote116 views1 answer
Resulting Query
SQL
0 vote124 views1 answer
Alter rename command in mysql
SQL
0 vote118 views1 answer
Get server date mysql
SQL
1 vote115 views1 answer
Mysql view current queries
SQL
3 votes122 views2 answers
Postgres alter table owner
SQL