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

2 votes229 views2 answers
Sql query to list all tables in a database sql server
SQL
0 vote187 views1 answer
Mysql sql select one day before
SQL
3 votes204 views3 answers
Mysql declare variable
SQL
50 votes308 views6 answers
Sql count duplicate rows
SQL
0 vote213 views2 answers
How do I install microsoft SQL on my Mac?
SQL
5 votes194 views1 answer
Alter table add comment oracle
SQL
-2 votes211 views1 answer
Group functions in sql
SQL
1 vote186 views1 answer
Substr sql last character
SQL
0 vote194 views1 answer
Will graphql replace sql
SQL
20 votes194 views4 answers
Sqlite create table if not exists
SQL