/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 vote234 views1 answer
Allow external access to mysql
SQL
1 vote219 views1 answer
Postgres regex remove special characters
SQL
7 votes254 views4 answers
Index in mysql
SQL
6 votes227 views2 answers
Clear a table in mysql
SQL
0 vote203 views0 answer
SQL
0 vote249 views1 answer
Get only one row in mysql
SQL
1 vote244 views1 answer
Where date = max(date) in sql
SQL
2 votes237 views1 answer
Oracle list grants on package
SQL
0 vote229 views1 answer
Contact mysql column field
SQL
3 votes322 views1 answer
How to get yesterday date in sql
SQL

Share