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 vote197 views2 answers
What is the default password for sql server sa
SQL
0 vote177 views1 answer
Mysql select smaller of two values
SQL
0 vote166 views1 answer
Change database name psql 8
SQL
0 vote172 views1 answer
Sql replace id with name from another table
SQL
1 vote195 views5 answers
What is in operator in sql
SQL
0 vote224 views1 answer
Two inner joins sql
SQL
0 vote202 views4 answers
Convert databse to achieve log mode oracle
SQL
0 vote170 views1 answer
How to print mysql query of codeigniter query builder
SQL
18 votes168 views3 answers
Mysql current date
SQL
3 votes269 views1 answer
Postgresql today - 1 year
SQL