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 vote140 views2 answers
Create sequence if not exists postgres
SQL
7 votes126 views1 answer
Forge server hosting
SQL
2 votes141 views1 answer
Oracle table size
SQL
0 vote137 views3 answers
Java hide mysql login credentials
SQL
1 vote153 views1 answer
Top 10 rows in mysql
SQL
0 vote299 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL
0 vote147 views1 answer
Select all columns except one sql
SQL
0 vote156 views1 answer
Sql out file formate
SQL
0 vote141 views3 answers
How to increase size of column in sql
SQL
0 vote126 views1 answer
Using GROUP BY in MySQL Join Table
SQL