Faster mysql imports

#Innodb before import:
SET FOREIGN_KEY_CHECKS = 0;
SET UNIQUE_CHECKS = 0;
SET AUTOCOMMIT = 0;
#After import:
SET UNIQUE_CHECKS = 1;
SET FOREIGN_KEY_CHECKS = 1;
COMMIT;

Source: support.tigertech.net

Faster mysql imports

#To disable MySQL indexes:
ALTER TABLE `table_name` DISABLE KEYS;
#To enable MySQL indexes:
ALTER TABLE `table_name` ENABLE KEYS;

Source: support.tigertech.net

Similar codes

2 votes113 views1 answer
Sql find missing values between two tables
SQL
0 vote113 views1 answer
See the structure of a table mysql
SQL
1 vote68 views1 answer
Postgresql last element of array
SQL
0 vote158 views1 answer
Store case result sql
SQL
1 vote133 views1 answer
Check current sequence value postgres
SQL
0 vote118 views1 answer
Not equal to blank in mysql
SQL
0 vote112 views1 answer
FIND AVERAGE SALARY EARNER IN SQL
SQL
0 vote110 views2 answers
Mysql unique two columns
SQL
2 votes111 views1 answer
Sql create database
SQL
16 votes122 views3 answers
Jwt secret key generator laravel
SQL