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

12 votes295 views5 answers
Sql merge
SQL
-1 vote290 views1 answer
Add bool column in sql
SQL
1 vote309 views1 answer
Mariadb.service: main process exited, code=exited, status=1/failure
SQL
0 vote290 views1 answer
Java spring boot connect to sql server
SQL
1 vote279 views1 answer
Mysql show data from table
SQL
5 votes295 views1 answer
Oracle ora-00054 resource busy
SQL
1 vote331 views1 answer
Oracle dbms scheduler repeat interval every 5 minutes
SQL
0 vote287 views1 answer
Search In the Data using ObjectName
SQL
0 vote315 views1 answer
How to remove quotes from a string in ssis load file
SQL
0 vote289 views1 answer
Oracle synonym procedure
SQL