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 vote304 views1 answer
Oracle procedure teamplate
SQL
0 vote320 views1 answer
Convert uniqueidentifier to varchar in sql
SQL
4 votes293 views1 answer
Check database name postgresql
SQL
2 votes331 views1 answer
Coalesce sql
SQL
0 vote306 views1 answer
Create table sql generator
SQL
0 vote264 views1 answer
Kannst du deine finger trainieren
SQL
1 vote295 views1 answer
Get table which have specific columns in mysql
SQL
3 votes306 views1 answer
Stpop start psql server
SQL
0 vote319 views1 answer
Set Mamp mysql globally
SQL
0 vote310 views2 answers
Mysql row_number() example
SQL