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 vote364 views1 answer
MySQL INSERT IGNORE Statement
SQL
29 votes348 views5 answers
Mysql show table structure
SQL
0 vote355 views1 answer
Sql stored procedure update if parameter is not null
SQL
0 vote345 views1 answer
18446744073709551615 mariadb left join order by
SQL
1 vote362 views1 answer
Oracle previous year
SQL
0 vote335 views1 answer
Download mysql database to excel in android studio
SQL
0 vote344 views1 answer
Sql waitfor
SQL
5 votes335 views2 answers
Oracle timestamp to date
SQL
0 vote320 views1 answer
How to drop columns with constraint from a table in sql script
SQL
0 vote361 views1 answer
In query in sql
SQL