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 vote262 views1 answer
Manage Database in MySQL
SQL
12 votes192 views1 answer
Script to add new column in table sql
SQL
9 votes209 views6 answers
Sql insert into
SQL
0 vote214 views1 answer
Set classpath for mysql-connector.jar
SQL
-1 vote202 views5 answers
Convert sql to linq query online
SQL
0 vote189 views1 answer
Events not working db
SQL
1 vote188 views1 answer
Mariadb get column names from table
SQL
1 vote183 views3 answers
Sql server get week dates from week number
SQL
2 votes206 views2 answers
Sqlalchemy return id after insert
SQL
0 vote234 views1 answer
Html css mobile menu arrow dropdown
SQL