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 vote183 views1 answer
Alter table add foreign key mariadb example
SQL
0 vote193 views1 answer
Get schema of table sql
SQL
103 votes301 views2 answers
Sql server LIKE '%%'
SQL
4 votes187 views1 answer
Conda install sqlalchemy
SQL
0 vote182 views1 answer
Sql drop default
SQL
1 vote196 views1 answer
Influxdb export to csv
SQL
0 vote231 views2 answers
Sql unique
SQL
0 vote193 views1 answer
Can you write relational algebra into sql queries
SQL
0 vote190 views2 answers
How to set global time_zone in mysql
SQL
0 vote181 views1 answer
Sql contains numeric characters
SQL