I have a user table in a mysql db, when a user is inserted, I need the
generated keyfield from their entry to enter data into another table.
To accomplish this I insert the user and immediately after, run
another query using the LAST_INSERT_ID() command. This seems to work,
but isn't there a possibility that inbetween these two queries,
another user could register and the LAST_INSERT_ID return the wrong
If so, is there a better way of doing this? I tried executescaler on
the insert, but it always returned nothing.
Any help would be appreciated!...