/SQL/Cannot truncate a table referenced in a foreign key constraint

Cannot truncate a table referenced in a foreign key constraint

Cannot truncate a table referenced in a foreign key constraint

SET FOREIGN_KEY_CHECKS = 0; 
TRUNCATE table $table_name; 
SET FOREIGN_KEY_CHECKS = 1;

3

Source: stackoverflow.com

Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint

As the error says, you can not truncate tables referenced by foreign keys. 
Delete should work though...

DB::table('some_table')->delete();

0

How to force truncate a table in mysql

DELETE FROM mytest.instance;
ALTER TABLE mytest.instance AUTO_INCREMENT = 1;

0

Similar codes

150 votes616 views10 answers
Grepper
SQL
0 vote326 views2 answers
Mysql password error create datbase
SQL
0 vote328 views1 answer
Sqlite closes value
SQL
1 vote349 views1 answer
Add many column to sap iq table
SQL
2 votes434 views1 answer
Ssh mysql port forwarding
SQL
2 votes346 views2 answers
Sql percentage
SQL
10 votes311 views2 answers
Django mysql
SQL
0 vote353 views1 answer
How to start my sql server on mac
SQL
0 vote320 views1 answer
Import all databases mysql
SQL
1 vote374 views1 answer
Delete mysql ubuntu 20.04
SQL

Share