So, is there a way to only check for the FKs constraint at the end of the transaction, and not at the rigth moment of the insert????
Not in MySQL. Other databases have functionality named deferred constraints, where constraint checking is deferred to transaction commit, but MySQL doesn't have them.
Jochem
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
