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

-1 vote202 views2 answers
Get day in sql
SQL
0 vote210 views1 answer
Object of class mysqli_result could not be converted to string
SQL
8 votes253 views2 answers
Default sql server port
SQL
0 vote213 views1 answer
Connect by query in oracle
SQL
2 votes200 views2 answers
Oracle no data found error code
SQL
-1 vote249 views1 answer
Search all sql tables for a value
SQL
0 vote213 views1 answer
Uncheck constraints and delete from table
SQL
0 vote291 views1 answer
DATEDIFF minute postgres
SQL
0 vote192 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
1 vote230 views1 answer
Oracle plan hash value
SQL