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 vote300 views1 answer
Generate random & unique mysql string
SQL
0 vote306 views1 answer
Primary key multiple colums
SQL
0 vote289 views1 answer
Str_to_date sql server
SQL
1 vote282 views2 answers
Sqlalchemy postgres timestamp with timezone
SQL
0 vote280 views1 answer
Components/Fields of Internal Table
SQL
0 vote280 views1 answer
Sql select with apostrohpe
SQL
0 vote300 views2 answers
Functions with parameters SQL
SQL
0 vote272 views2 answers
How to see table associated with a schema in sql
SQL
0 vote334 views1 answer
Python dictionary to sql update
SQL
6 votes294 views1 answer
Oracle list primary key
SQL