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? 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