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

36 votes361 views6 answers
Delete from where sql
SQL
0 vote378 views1 answer
How to inner join 4 tables in sql
SQL
0 vote362 views1 answer
Providername system.data. mysql
SQL
0 vote347 views1 answer
Sql query to find duplicate email address
SQL
2 votes357 views3 answers
Current setting postgres timezone
SQL
0 vote405 views1 answer
Python get backup of sql
SQL
19 votes351 views4 answers
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
SQL
11 votes361 views4 answers
MYSQL LOGIN
SQL
0 vote336 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
0 vote328 views1 answer
Google cloud sql postgres url example
SQL