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

7 votes112 views1 answer
Mysql iif
SQL
0 vote59 views1 answer
Oracle list all stored procedures
SQL
17 votes124 views2 answers
Mysql date to string
SQL
2 votes61 views2 answers
Mysql get last character of string
SQL
9 votes101 views2 answers
Cmd to rename a collumn name in sql
SQL
1 vote111 views3 answers
Default password of mysql
SQL
0 vote115 views1 answer
Mysql backup certain tables workbench
SQL
0 vote122 views1 answer
What logs are available on RDS MySQL?
SQL
0 vote104 views1 answer
Sql server udf performance
SQL
0 vote123 views1 answer
Least spark sql
SQL