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

1 vote217 views2 answers
Changes not showing on website server odoo
SQL
7 votes220 views3 answers
Convert ansi sql
SQL
18 votes230 views3 answers
Get the list of all tables in sql server
SQL
0 vote209 views1 answer
Sql case when exists in another table
SQL
3 votes208 views4 answers
Mysql create table from select statement
SQL
1 vote205 views1 answer
Apex run 404
SQL
2 votes210 views3 answers
Write sql query to find the second highest salary of employee
SQL
1 vote224 views2 answers
Oracle list service names
SQL
5 votes217 views1 answer
Oracle get foreign keys on table
SQL
2 votes248 views1 answer
Get the mysql table columns data type mysql
SQL