MySQL inserting row + rows at a time in to two tables probs
Posted: Tue Mar 01, 2005 7:21 am
I have two tables
Submission
and file_info
when I insert a row in to the Submission Table a sub_id is generated automatically and as soon as I insert a row
I am trying to insert some rows in to file_info which Has a column called sub_id
and I have difficulty in getting the sub_id as soon as the row is inserted so that I can use that in the file_info table
is there any thing called as Select sub_id on inserting the row Blah blah..
Submission
and file_info
when I insert a row in to the Submission Table a sub_id is generated automatically and as soon as I insert a row
I am trying to insert some rows in to file_info which Has a column called sub_id
and I have difficulty in getting the sub_id as soon as the row is inserted so that I can use that in the file_info table
is there any thing called as Select sub_id on inserting the row Blah blah..