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 vote198 views1 answer
How to use lower case in mysql
SQL
0 vote197 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
104 votes1.1K views2 answers
Like in mysql
SQL
0 vote201 views1 answer
Sql comand for removing data from table
SQL
1 vote184 views4 answers
Sequelize migration default value
SQL
2 votes183 views1 answer
Sql create database
SQL
19 votes304 views5 answers
Mysql between date range
SQL
5 votes230 views2 answers
Oracle show procedures
SQL
25 votes202 views6 answers
Import mysql database command line
SQL
0 vote269 views1 answer
How to make full text search dynamic in mysql
SQL