/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

0 vote184 views1 answer
Set Mamp mysql globally
SQL
17 votes188 views4 answers
Show tables sql server
SQL
0 vote169 views1 answer
Connect to ssms with python
SQL
0 vote167 views1 answer
Search In the Database using Text
SQL
0 vote241 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
1 vote155 views1 answer
Sql group by error
SQL
0 vote195 views1 answer
Mysql average from two table
SQL
4 votes166 views1 answer
What are the data types in sql
SQL
0 vote180 views1 answer
Query params sql insert python f string
SQL
0 vote180 views1 answer
How to add unique key constraint in mysql
SQL

Share