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

3 votes196 views2 answers
Savepoint in sql
SQL
1 vote144 views1 answer
How to fetch data in between startfromdate to starenddate in sql
SQL
0 vote111 views1 answer
Datetime postgres typeorm
SQL
1 vote132 views1 answer
SQl Server Versionen Releases und Build-Nummern
SQL
0 vote154 views5 answers
Select concat alter table mysql
SQL
4 votes115 views3 answers
Sql find second highest salary employee
SQL
0 vote79 views1 answer
Store query result in variable sql
SQL
1 vote141 views1 answer
Oracle apex version view
SQL
0 vote111 views1 answer
Initcap in sql
SQL
2 votes111 views1 answer
Oracle number to percentage
SQL