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

5 votes182 views2 answers
Sql number columns
SQL
7 votes178 views3 answers
Restore postgres database from sql file
SQL
14 votes196 views1 answer
Oracle alter table add column not null
SQL
0 vote166 views1 answer
Update if else mysql
SQL
1 vote160 views1 answer
Oracle start job
SQL
0 vote182 views2 answers
What is rownum in oracle
SQL
0 vote175 views1 answer
Mysql case when null
SQL
3 votes168 views2 answers
Current year sql
SQL
0 vote191 views1 answer
Shrink database file in sql server
SQL
0 vote175 views1 answer
Add sqlite3 in lumen
SQL