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 vote192 views1 answer
Sqlite3 update select
SQL
0 vote212 views1 answer
Mysql relationships between tables
SQL
2 votes199 views1 answer
Oracle list duplicates
SQL
14 votes227 views1 answer
Excel is not a database
SQL
2 votes163 views2 answers
How to get capital letter first in sql
SQL
0 vote170 views1 answer
Remove default constraint sql server
SQL
16 votes181 views1 answer
CTE statement sql server
SQL
0 vote226 views1 answer
Sql select merge multiple values
SQL
3 votes221 views4 answers
Mysql create table from select statement
SQL
12 votes175 views2 answers
Delete entries in postgresql
SQL