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

4 votes161 views1 answer
Refresh postgres config
SQL
1 vote175 views2 answers
Remove space in mysql
SQL
0 vote187 views1 answer
Get from database the most recent data limit by 5
SQL
1 vote150 views1 answer
Store select query result in variable sql server
SQL
0 vote194 views1 answer
Authentication modes in sql server
SQL
0 vote157 views1 answer
Print mysql
SQL
10 votes171 views2 answers
Forgot my mysql password mac
SQL
0 vote171 views1 answer
Sql server on mac m1
SQL
1 vote234 views2 answers
Truncate table sqlite
SQL
0 vote163 views1 answer
Hibernate show sql xml property
SQL