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 vote388 views1 answer
Cube oracle
SQL
0 vote360 views1 answer
Run mysql xampp shell
SQL
2 votes367 views1 answer
Oracle generated column
SQL
0 vote385 views2 answers
Select a row include list of array with join two table SQL
SQL
0 vote344 views1 answer
Replace \n sql
SQL
1 vote358 views1 answer
Error code 1292 mysql workbench
SQL
1 vote330 views3 answers
Default password of mysql
SQL
0 vote402 views2 answers
How to install psql in ubuntu
SQL
4 votes344 views1 answer
Select nls_date_format
SQL
0 vote363 views1 answer
Alter rename command in mysql
SQL