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 vote131 views1 answer
Order by in codeigniter query builder
SQL
94 votes155 views4 answers
Create database postgres
SQL
2 votes186 views1 answer
Tsql copy table
SQL
1 vote121 views3 answers
Getdate function in postgresql
SQL
14 votes189 views1 answer
How to export db from mysql
SQL
0 vote131 views1 answer
Renombrar tabla mysql
SQL
0 vote125 views1 answer
Can't connect to postgresql mac os
SQL
0 vote133 views1 answer
Creating a simple notify in postgresql
SQL
0 vote125 views1 answer
Get null value in sql
SQL
0 vote137 views4 answers
Open mysql port bitnami tomact
SQL