To solve the MySQL clean table times 1701 wrong way

Empty tables with foreign KEY constraints The Times error 1701 (42000)

Cannot truncate a table referenced in a FOREIGN KEY constraint (' laravel-test '. ' Bl_role_user ', constraint ' Role_user_role_ Id_foreign ' foreign KEY (' role_id ') REFERENCES ' laravel-test '. ' Bl_roles ' (' ID ')

Solutions:

Turn off the foreign key constraint-> empty the table-> start the foreign key constraint.

Example:

Mysql> SET foreign_key_checks=0;

mysql> truncate TABLE bl_roles;

Mysql> SET Foreign_key_checks=1;