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 vote130 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
0 vote122 views1 answer
Mysql coonect sample code
SQL
3 votes109 views1 answer
Async await mysql nodejs
SQL
3 votes115 views2 answers
Enter mysql command line
SQL
0 vote110 views1 answer
Mysql bash execute sql file
SQL
0 vote100 views1 answer
Sql random decimal
SQL
0 vote109 views1 answer
Eliminar ultimo carcacter mysql
SQL
5 votes116 views3 answers
Truncate function in sql oracle
SQL
0 vote133 views1 answer
Sql tablo sp
SQL
0 vote122 views1 answer
Mysql could not fetch tables
SQL