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

5 votes203 views1 answer
Dbms_metadata.get_ddl table
SQL
1 vote193 views2 answers
List tables sqlalchemy
SQL
0 vote302 views1 answer
Hue hive UploadingTextFiletoHive
SQL
0 vote186 views1 answer
Get initials name in sql
SQL
1 vote159 views2 answers
Reset mysqli fetch_arra
SQL
17 votes157 views6 answers
Change column name in sql
SQL
15 votes305 views2 answers
Sql order by alphabetical
SQL
0 vote153 views1 answer
Mysql filter based on datediff
SQL
1 vote166 views2 answers
Mysql insert generate serie
SQL
0 vote156 views1 answer
One table with another
SQL