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 vote110 views1 answer
Sql padd let with zeros
SQL
1 vote105 views1 answer
Show indices in mysql table
SQL
5 votes98 views1 answer
Sysdate in oracle sql
SQL
-1 vote93 views2 answers
Sql server date format yyyy-MM-ddThh:mm:ss
SQL
3 votes107 views1 answer
Make a field auto_increment mysql
SQL
0 vote129 views1 answer
Local pg_sql to heroku pg_sql
SQL
0 vote101 views1 answer
Sql convert datetime to year
SQL
6 votes98 views1 answer
Oracle trigger after logon on database
SQL
0 vote220 views1 answer
The differnece between to values in sql
SQL
0 vote98 views1 answer
Find largest table in mysql database
SQL