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

45 votes212 views5 answers
Grant all privileges mysql
SQL
0 vote110 views1 answer
Ms sql unique
SQL
1 vote133 views2 answers
Postgres copy table from one schema to another
SQL
0 vote146 views1 answer
Drop table BigQuery table columns
SQL
0 vote150 views1 answer
Carbon mysql d m y to y-m-d
SQL
17 votes152 views2 answers
Mysql date to string
SQL
4 votes129 views2 answers
Mysql select where starts with
SQL
1 vote133 views1 answer
Oracle difference between two dates in years
SQL
0 vote135 views1 answer
Amount of entries in a table psql
SQL
0 vote257 views1 answer
Generate a random otp in sql server
SQL