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

2 votes305 views1 answer
Postgresql create table as select
SQL
0 vote318 views2 answers
ON DUPLICATE KEY UPDATE for postgres
SQL
0 vote290 views1 answer
Sql date between one week
SQL
0 vote318 views1 answer
For row in sql database python loop
SQL
2 votes289 views1 answer
Sql server case sensitive search
SQL
0 vote260 views1 answer
Sql server current time without date
SQL
2 votes261 views3 answers
Application.properties spring boot mysql
SQL
1 vote285 views1 answer
Mysql data from file
SQL
0 vote307 views1 answer
Sql with example
SQL
0 vote274 views3 answers
Sql delete all except
SQL