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 vote112 views1 answer
How to set up an anonymous function to variable in swift
SQL
2 votes102 views1 answer
Get first n letter of department name in sql
SQL
33 votes108 views6 answers
Sql delete
SQL
8 votes101 views2 answers
Mysql grant all privileges to user from any host
SQL
19 votes106 views6 answers
Sql server drop table if exists
SQL
2 votes150 views1 answer
Oracle Column Names of a table
SQL
0 vote110 views1 answer
Sql search all columns of database oracle sql
SQL
3 votes125 views2 answers
Synonym oracle
SQL
2 votes122 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
0 vote118 views1 answer
How to find table lock and row lock in mysql
SQL