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

0 vote215 views1 answer
How to connect to xampp sql server on windows cmd
SQL
0 vote229 views1 answer
Sql query to find percentage of null values in a table
SQL
3 votes208 views1 answer
Créer une table sql
SQL
3 votes213 views1 answer
Null sql
SQL
0 vote224 views1 answer
C# get sql min date
SQL
1 vote210 views7 answers
Filter
SQL
2 votes189 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
6 votes207 views5 answers
Mysql get last insert id
SQL
0 vote156 views1 answer
Mysql collation for all languages
SQL
18 votes186 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
SQL