At 11:42 -0500 3/20/02, Andrew Hazen wrote: >Hi, >I am loading table A from values in table B with an insert . . . select >statement. >I also need to populate a x-ref table with the new insert ids from the >insert . . . select. > >I know in Oracle I would put a trigger in to do the x-ref insert after >each row of the insert. . .select is processed. > >Is there anyway to do this in mysql/php?
Yes, you do it yourself. :-) You'll probably find the PHP mysql_insert_id() function helpful in your situation. > > >Spamfilter: mysql > >Andrew Hazen >Database Developer >Jatech Solutions Inc. >160 Bartley Drive >Toronto, ON >M4A 1E1 >www.jatech.ca >416-288-9833 > --------------------------------------------------------------------- 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
