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

1 vote211 views1 answer
Complete output (15 lines): /bin/sh: 1: mysql_config: not found /bin/sh: 1: mariadb_config: not found /bin/sh: 1: mysql_config: not found Traceback (most recent call last): File "<string>", line 1, in <module> File "/tmp/pi
SQL
0 vote213 views1 answer
Sql value exists in column
SQL
2 votes218 views1 answer
Mysql Incorrect column specifier for column
SQL
1 vote216 views1 answer
Postgres first_value in gropby
SQL
0 vote206 views1 answer
How to export table data from mysql table in sql format
SQL
0 vote209 views1 answer
Copy data from cell to cell mysql
SQL
1 vote208 views2 answers
Sql groub by count
SQL
1 vote220 views1 answer
Psql lst trigger
SQL
0 vote234 views1 answer
Materialized view redshift
SQL
7 votes196 views2 answers
Create mysql user
SQL