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

7 votes281 views2 answers
Html to react converter
SQL
0 vote288 views3 answers
CONTACT FORM SQL
SQL
0 vote275 views2 answers
Select columns from 2 tables with foreign key
SQL
0 vote285 views1 answer
Python connect to mysql in settings.py
SQL
0 vote273 views2 answers
Mysql create table if not exists
SQL
3 votes296 views1 answer
Laravel paginate raw sql
SQL
0 vote258 views2 answers
Change database postgres
SQL
1 vote302 views1 answer
Psql view enum values
SQL
1 vote273 views1 answer
Drop table if exists oracle
SQL
0 vote264 views1 answer
Mysql replication change database name
SQL