MySql NO ACTION for ON DELETE and ON UPDATE
Log from IRC server Freenode (IPv6) channel #SQL.
I don't remember the question but it's about mysql relationnal actions: ON DELETE, ON UPDATE.
<me> _W_: sorry for the delay, without my nick I wasn't notified. the context is on the bottom of the page http://www.go4expert.com/forums/showthread.php?t=13386 in the section ON DELETE item RESTRICT, I don't understand what this means : From MySQL Manual: Some database systems have deferred checks, and NO ACTION is a deferred check.
<_W_> ah, it means should the check be done immediately, or at the end of the transaction
<_W_> eg if you have a foreign key check, you might in some cases want to insert the element that referrs to another before that other element, and to do that you need a deffered check, so the foreign key restriction is only checked at the end, when that object is also inserted
