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 vote226 views1 answer
Renombrar tabla mysql
SQL
0 vote230 views1 answer
Guid string to binary better
SQL
0 vote191 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
0 vote226 views1 answer
Enlever les doubles espaces dans les tables postgresql
SQL
0 vote222 views1 answer
Select all same column value in sql
SQL
0 vote216 views1 answer
Npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! [email protected] install: `node-pre-gyp install --fallback-to-build` npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the [email protected] install script.
SQL
3 votes228 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
6 votes191 views2 answers
Spring data jpa application.properties mysql
SQL
0 vote229 views1 answer
Sequelize postgresql schema
SQL
2 votes247 views1 answer
Q operator in oracle
SQL