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 vote341 views1 answer
Get time component of datetime sql
SQL
7 votes385 views1 answer
Sql disable safe mode
SQL
0 vote355 views2 answers
How to save result of sqlite query in a table
SQL
0 vote371 views1 answer
The report definition has an invalid target namespace 'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'
SQL
0 vote373 views1 answer
Lost connection to mysql
SQL
8 votes354 views1 answer
Alter tablespace add datafile autoextend
SQL
0 vote365 views2 answers
How to generate a unique random number in mysql
SQL
4 votes368 views1 answer
Describe table mysql
SQL
0 vote397 views2 answers
Insert data mysql with cmd
SQL
0 vote367 views1 answer
Sql pad left 0
SQL