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

-2 votes284 views1 answer
Mysql not empty
SQL
1 vote191 views1 answer
Oracle select first result
SQL
0 vote197 views1 answer
Postgresql parse json array
SQL
0 vote214 views1 answer
How to add more columns to a table in mysql
SQL
1 vote213 views1 answer
Age postgres
SQL
3 votes197 views2 answers
Sql server current date without time
SQL
7 votes211 views2 answers
N highest salary in sql
SQL
0 vote242 views1 answer
Check command
SQL
0 vote223 views1 answer
Psql no such file or directory
SQL
1 vote244 views1 answer
Ora-01109 database not open in oracle 19c
SQL