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

12 votes370 views4 answers
How to take database dump in postgresql
SQL
0 vote356 views1 answer
Sql_inner_join
SQL
2 votes352 views2 answers
How to get capital letter first in sql
SQL
5 votes390 views1 answer
Oracle nls session
SQL
0 vote390 views1 answer
How to create notes in mysql
SQL
0 vote336 views1 answer
Sql roll up rows into columns
SQL
0 vote358 views1 answer
Vbscript clean up ADODB.Recordset
SQL
1 vote346 views1 answer
Local sql server
SQL
2 votes337 views3 answers
Replace null in sql
SQL
0 vote379 views1 answer
Varchar2 length in oracle
SQL