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

2 votes330 views1 answer
Q operator in plsql
SQL
0 vote288 views1 answer
INSERT INTO table using OpenQuery
SQL
-1 vote313 views5 answers
Online sql to linq generator
SQL
16 votes354 views1 answer
Sqlserver add column to table
SQL
1 vote345 views1 answer
Encrypt password postgresql
SQL
4 votes292 views1 answer
Psql get sequences
SQL
4 votes293 views1 answer
Mysql biginteger size
SQL
4 votes324 views1 answer
Postgresql list sequences
SQL
3 votes322 views2 answers
To_char sql
SQL
7 votes291 views1 answer
Query delete duplicates
SQL