Cannot truncate a table referenced in a foreign key constraint mysql error

Cannot truncate a table referenced in a foreign key constraint mysql error

Trying to update the schema or truncating the table or something else and got this error?
Turn the constraint temporarily and the issue shall be fixed:

SET FOREIGN_KEY_CHECKES=0;
TRUNCATE TABLE somepoortable;
.
.
SET FOREIGN_KEY_CHECKS=1;

That is it!

Java Tomcat error: can not access a member of class with modifiers

Add scrollbar to mysql result in terminal

You asked to pull from the remote but did not specify the branch github error

Maven error Annotations are not supported in -source 1.3

mysql command not found on mac after installation

eclipse j2ee error There are No resources that can be added or removed from the server

Leave a Reply

Your email address will not be published. Required fields are marked *

*
*