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

1 vote140 views1 answer
Ilike for date postgres
SQL
1 vote145 views1 answer
Oracle add proxy
SQL
3 votes145 views4 answers
Mysql decimal
SQL
0 vote150 views1 answer
How to put value in parameters in mysqldataadapter
SQL
1 vote149 views1 answer
SQL query to get all table records count from a database
SQL
5 votes149 views1 answer
Mysql count lines
SQL
31 votes150 views3 answers
SQL Server change column data type
SQL
0 vote140 views1 answer
Sql contains numeric characters
SQL
19 votes151 views3 answers
Grant mysql
SQL
0 vote156 views1 answer
Mysql date equals to current_date plus days
SQL