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 votes259 views2 answers
Create index mysql cli
SQL
0 vote250 views1 answer
Which sql statement would you use to remove a view called emp_dept_vu from your schema?
SQL
1 vote264 views1 answer
Adding indexing on a db model in mysql using sequelize
SQL
0 vote239 views1 answer
Mysql> grant all privileges on *.* to root@localhost identified by 'password' with grant option;
SQL
0 vote244 views1 answer
C# datetime to sql server datetime
SQL
0 vote252 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL
0 vote256 views1 answer
Contact mysql column field
SQL
31 votes256 views4 answers
How to get duplicate records with multiple field in sql
SQL
10 votes255 views2 answers
Linux command line import mysql database
SQL
3 votes246 views5 answers
Mysql get last inserted id
SQL