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 vote201 views2 answers
Plsql function that return a table
SQL
1 vote207 views1 answer
Blob datatype in mysql
SQL
0 vote192 views1 answer
Stored procedure function relation
SQL
0 vote147 views1 answer
Insert and initialize a SQL column with value dependent on another column data
SQL
4 votes205 views4 answers
Check constraint in ms sql
SQL
0 vote231 views2 answers
Select index table oracle
SQL
1 vote192 views3 answers
Mysql disable foreign keys check
SQL
0 vote336 views1 answer
Android sqlite add column if not exists
SQL
7 votes193 views1 answer
Minecraft forge server host
SQL
3 votes282 views4 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client vs code
SQL