Mysql faster insert

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 vote334 views1 answer
Sql insert tuple
SQL
0 vote317 views1 answer
Create table employees oracle
SQL
0 vote352 views2 answers
Nodejs mysql convert to plain object
SQL
0 vote329 views1 answer
Mysql add to value
SQL
0 vote343 views1 answer
Sql server get date of previous sunday
SQL
0 vote344 views1 answer
Selecting all columns from table sql database
SQL
1 vote346 views1 answer
Postgresql pass array in function
SQL
-1 vote359 views1 answer
How to change the auto increment in existing table mysql
SQL
0 vote335 views1 answer
Min and max salary and name in sql
SQL
32 votes423 views6 answers
Rename column mysql
SQL