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

1 vote258 views1 answer
Mysql show table character set
SQL
0 vote285 views1 answer
Drop tables from local database postgres pgadmin
SQL
0 vote280 views1 answer
Check if a column is a primary key in sql server
SQL
0 vote289 views1 answer
Mysql delete entire row on condition
SQL
0 vote296 views1 answer
SQL Hello, [firstname] [lastname]
SQL
7 votes271 views1 answer
Xampp reset mysql
SQL
0 vote286 views1 answer
Consecutive numbers sql
SQL
0 vote270 views1 answer
Contraint default SQL
SQL
2 votes259 views1 answer
Sql update alias
SQL
0 vote289 views1 answer
How to get column name in db from an sqlalchemy attribute model
SQL