I was reading the information on foreign keys in the manual
http://www.mysql.com/doc/e/x/example-Foreign_keys.html
and noticed that there is no mention of locking the tables.
It seems to me that using the example verbatim could lead to loss of
referencial integrity if INSERTS did not occur in sequence (i.e. another
person was inserted before shirts).
Using "LAST_INSERT_ID()" can only be guranteed to work if the tables are
locked.
Am I correct or did I miss something?
___________________________________
Scott A. Gerhardt P.Geo.
Gerhardt Information Technologies
[EMAIL PROTECTED]
___________________________________
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
