Hi, > How do I execute the following UPDATE statements such that I can ensure > that all integrity constraints are maintained upon the completion of the > last one?
> UPDATE test_parent SET id = 6 WHERE id = 1; > UPDATE test_child SET parent_id = 6 WHERE parent_id = 1; And would specifying ON UPDATE CASCADE help? That's what it's meant to do, right? Take care, Aleksandar -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]