MySQL force delete rows

Author: Ahmad
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

SET FOREIGN_KEY_CHECKS = 0

to reactivate it

SET FOREIGN_KEY_CHECKS =1

 

enjoy

«
»

    Leave a Reply

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

    CAPTCHA

    *

    This site uses Akismet to reduce spam. Learn how your comment data is processed.