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 votes256 views3 answers
Mysql get table size
SQL
0 vote184 views1 answer
Postgres meta command to show all rows in table
SQL
3 votes182 views2 answers
See mysql users ubuntu
SQL
-1 vote177 views1 answer
Utf8_encode mysql
SQL
0 vote157 views1 answer
Sql clear table
SQL
0 vote182 views2 answers
How to get the date from datetime in mysql
SQL
0 vote160 views1 answer
Vbscript create ADODB.Connection
SQL
5 votes171 views1 answer
Mysql count lines
SQL
32 votes180 views6 answers
How to change column name in sql
SQL
0 vote174 views1 answer
Ksql quickstart docker
SQL