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 vote253 views1 answer
Postgres jsonb array push new element
SQL
2 votes268 views1 answer
Sql percentage with % rounded down
SQL
0 vote285 views1 answer
Cube oracle
SQL
0 vote299 views2 answers
Postgres isnull
SQL
2 votes246 views1 answer
How to select first row of database sql
SQL
3 votes267 views1 answer
Two select sql
SQL
0 vote258 views1 answer
Mysql coonect sample code
SQL
15 votes248 views2 answers
How to know the username of postgresql
SQL
0 vote268 views2 answers
Dbms interview questions
SQL
0 vote290 views1 answer
Fetching data from mysqldb
SQL