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 vote141 views1 answer
Create table employees oracle
SQL
3 votes163 views2 answers
How to start postgresql on windows
SQL
14 votes167 views1 answer
Oracle alter table add column not null
SQL
1 vote164 views1 answer
SQLSTATE[HY000] [2002]
SQL
0 vote164 views1 answer
Unique index in mysql
SQL
1 vote237 views1 answer
SQL server query column yes or no
SQL
0 vote197 views1 answer
Mysql c commands
SQL
0 vote153 views1 answer
Start and stop mysql
SQL
1 vote224 views1 answer
Ora-06502: pl/sql: numeric or value error: character string buffer too small
SQL
1 vote143 views3 answers
How to filter repeated same result using sql query
SQL