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 vote238 views1 answer
Version_info, _mysql.version_info, _mysql.__file__ NameError: name '_mysql' is not defined
SQL
7 votes245 views2 answers
Mysql get year from date
SQL
6 votes245 views1 answer
T-sql test if table exists
SQL
1 vote243 views1 answer
Sql server insert into temp table
SQL
1 vote235 views1 answer
Join to find results not in another table
SQL
0 vote226 views1 answer
Implicit inner join table alias with id values
SQL
0 vote250 views1 answer
Update having mysql
SQL
0 vote249 views1 answer
Sql insert query list of dictionaries
SQL
1 vote245 views3 answers
Connect to mysql c# connection string C#
SQL
0 vote250 views1 answer
Limit in access query
SQL