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 vote141 views1 answer
Get number of table colums in sql query
SQL
7 votes160 views1 answer
Sql limit decimal places
SQL
0 vote148 views1 answer
SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
SQL
3 votes150 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL
0 vote140 views1 answer
Execute sql stored procedure in powershell
SQL
0 vote141 views1 answer
Show create table in postgresql
SQL
16 votes142 views2 answers
Mysql date between two dates
SQL
0 vote130 views1 answer
Sql cross apply vs join
SQL
0 vote151 views1 answer
Psql generate id in existing database
SQL
5 votes138 views1 answer
JBDC
SQL