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

42 votes446 views6 answers
Install beautifulsoup
SQL
3 votes371 views3 answers
C# sql select
SQL
5 votes357 views1 answer
Commentaire table oracle
SQL
0 vote355 views1 answer
Install package for sqlserver in asp.net core
SQL
0 vote397 views1 answer
Arithmetic expression in sql
SQL
0 vote401 views3 answers
Mysql keyword search
SQL
0 vote361 views1 answer
Insert into select with group by
SQL
0 vote381 views1 answer
Unable to convert mysql date/time value to system.datetime
SQL
10 votes329 views1 answer
Dba_dependencies
SQL
0 vote362 views1 answer
Select 1 from orders
SQL