MySQL force delete rows
Date: December 13, 2014
Categories: Databases
MySQL check if there is a relation between rows before deleting it
it will raise an error
can’t delete or update a parent row
we need to till mysql to stop this check
|
1 |
SET FOREIGN_KEY_CHECKS = 0 |
to reactivate it
|
1 |
SET FOREIGN_KEY_CHECKS =1 |
enjoy
This site uses Akismet to reduce spam. Learn how your comment data is processed.
Leave a Reply