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 vote119 views1 answer
Check if a word appears at the end sql query
SQL
0 vote130 views1 answer
Print mysql
SQL
0 vote144 views1 answer
.sql File Run in PSQL
SQL
0 vote126 views1 answer
Postgresql alter column nullable
SQL
0 vote123 views1 answer
Sql clear table
SQL
2 votes128 views2 answers
Sql first character
SQL
0 vote150 views1 answer
Stored procedure to change name of column for all dependent tables and views
SQL
0 vote127 views1 answer
Mysql search multiple tables
SQL
4 votes175 views1 answer
Sql select limit range
SQL
0 vote115 views1 answer
Dnsmasq.conf location macos
SQL