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 vote112 views2 answers
Homebrew nysql launch
SQL
0 vote241 views1 answer
The differnece between to values in sql
SQL
4 votes144 views5 answers
Get last query in codeigniter 4
SQL
2 votes110 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
0 vote134 views1 answer
How to insert same table data using mysql query
SQL
0 vote101 views1 answer
Difference between cross apply and inner join
SQL
1 vote306 views1 answer
Foreign key in oracle sql developer
SQL
2 votes252 views1 answer
Set auto increment from 1
SQL
0 vote155 views1 answer
Kimball data warehouse sql calendar
SQL
0 vote74 views1 answer
Get all stored procedures in sql server
SQL