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 votes136 views2 answers
Get database size mysql
SQL
2 votes153 views1 answer
Sql OR
SQL
3 votes89 views1 answer
If 0 return null else return query mysql
SQL
0 vote183 views1 answer
Add week ending date sql server
SQL
0 vote132 views1 answer
Python sql last insertend
SQL
2 votes123 views2 answers
Function in sql
SQL
0 vote140 views1 answer
Firebird where
SQL
10 votes143 views1 answer
Oracle dependencies table
SQL
0 vote144 views1 answer
Buscar nombre de columna en todas las tablas sql server
SQL
-1 vote190 views3 answers
MAKE TABLE FIT in oracle sql
SQL