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 vote142 views1 answer
Sqlite higher or equal
SQL
0 vote135 views1 answer
What is the difference between the LIKE and REGEXP operators in mysql?
SQL
3 votes96 views4 answers
Mysql delete duplicate rows
SQL
15 votes277 views2 answers
Sql order by alphabetical
SQL
0 vote156 views1 answer
Sqlite3 not commit
SQL
8 votes154 views2 answers
Grant all privileges database postgres to user
SQL
0 vote134 views1 answer
Oracle select invalid views
SQL
2 votes123 views1 answer
Mysql list users on ubuntu
SQL
0 vote175 views1 answer
Sql multiple into
SQL
5 votes131 views1 answer
Minecraft java port number
SQL