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 vote135 views1 answer
Postgre admin slow
SQL
0 vote150 views1 answer
Group by max date
SQL
0 vote162 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
0 vote279 views2 answers
Create fulltext index mysql
SQL
0 vote139 views2 answers
Postgres show current role
SQL
51 votes238 views6 answers
Opera gx
SQL
1 vote146 views1 answer
Minus vs intersect in sql
SQL
1 vote136 views1 answer
Oracle rolling back transactions
SQL
4 votes176 views1 answer
Rename stored procedure in sql server
SQL
0 vote136 views1 answer
Insert into using contant values and source table columns with sql
SQL