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 vote275 views1 answer
Jooq replace
SQL
2 votes287 views1 answer
Mariadb JSON_EXTRACT
SQL
-1 vote289 views1 answer
Mysql order by on condition
SQL
0 vote282 views1 answer
Get record which is available in one table but not in another mysql
SQL
0 vote304 views1 answer
Running mysql from bash sc
SQL
6 votes290 views6 answers
Count mysql
SQL
6 votes296 views3 answers
Error Code: 1055. Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mydb.term.year' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote290 views1 answer
Select all columns except one sql
SQL
0 vote277 views1 answer
Postgres full text search example
SQL
14 votes304 views1 answer
Oracle alter table add column not null
SQL