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

3 votes303 views1 answer
Sql several or
SQL
1 vote342 views1 answer
Age postgres
SQL
2 votes352 views2 answers
Create empty table from existing table
SQL
32 votes345 views6 answers
Sql count where
SQL
6 votes305 views1 answer
SQL insert all columns
SQL
0 vote322 views1 answer
How to combine rows in sql server procedure
SQL
0 vote326 views1 answer
Mysql timediff
SQL
0 vote315 views1 answer
Events not working db
SQL
0 vote317 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
0 vote327 views1 answer
Sql server list user permissions
SQL