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

0 vote210 views1 answer
Mysql show schema
SQL
1 vote191 views1 answer
Round one decimal place mysql
SQL
0 vote172 views1 answer
Select list is not in group by clause and contains nonaggregated column codeigniter
SQL
0 vote153 views2 answers
How to start postgresql laravel
SQL
2 votes163 views1 answer
Sqlite show table indexes
SQL
8 votes166 views1 answer
Today minus 15 days postgresql
SQL
3 votes170 views3 answers
Stop mysql ubuntu
SQL
0 vote180 views1 answer
Casterar postgres
SQL
0 vote160 views1 answer
Restart sql server command line linux
SQL
1 vote155 views1 answer
Postgresql export output table as a csv
SQL