Thanks for your responses Jeremy,
I'm just trying to clarify any misunderstandings I may have.
So, as far as the example goes, the relationships between shirts and people
is maintained by using the LAST_INSERT_ID (in one connection) but
referential integrity is not maintained in terms of foriegn keys for
subsequent deletes and updates since MySQL does not support them. Thus all
subsequent deletes and updates etc. must use explicit joins or reference by
primary key.
___________________________________
Scott A. Gerhardt P.Geo.
Gerhardt Information Technologies
[EMAIL PROTECTED]
___________________________________
> > So referential integrity is maintained but AUTO_INCREMENT values may
> > not be chronological?
>
> Nope. Referential integrity is not maintained.
>
> Jeremy
> --
> Jeremy D. Zawodny, <[EMAIL PROTECTED]>
> Technical Yahoo - Yahoo Finance
> Desk: (408) 328-7878 Fax: (408) 530-5454
> Cell: (408) 439-9951
>
---------------------------------------------------------------------
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