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 vote231 views1 answer
Sql from null to not null
SQL
31 votes193 views3 answers
SQL Server change column data type
SQL
0 vote181 views1 answer
Sql create text column limited values
SQL
0 vote205 views2 answers
Dbms transaction tutorialspoint
SQL
0 vote209 views1 answer
C# select Mysql
SQL
0 vote194 views1 answer
Create table with float datatype in sql server
SQL
0 vote191 views1 answer
Mysql set variable to today's date
SQL
1 vote176 views1 answer
Mysql get character set
SQL
1 vote190 views1 answer
Are NULL values in a database the same as that of blank space or zero?
SQL
0 vote185 views1 answer
Sql server check whether column has same equal values
SQL