/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

20 votes106 views6 answers
Change password in mysql
SQL
1 vote99 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
5 votes96 views1 answer
Mysql select greater than yesterday
SQL
2 votes106 views1 answer
Sqlite show table indexes
SQL
15 votes128 views4 answers
Mysql export database command line
SQL
1 vote114 views1 answer
How to truncate a table in databse
SQL
8 votes112 views1 answer
Show mysql user table
SQL
1 vote103 views4 answers
Get week day from date in sql
SQL
7 votes100 views1 answer
Alter sequence set current value oracle
SQL
1 vote102 views2 answers
How to search date in sql query
SQL

Share