> what if i need the primary key of a row that is to be inserted? that
> key will be used to insert another row from another table.. what i was
> was after inserting the row, i get the primary key by select statement and
> use that value to insert a row from another table.. is this ok? are there
> any more efficient ways of doing this?
I take it you mean a "primary key value that comes from an auto-increment
Next, we have to assume you're doing this:
insert into mytable ( ... ) values ( ... )
select max(ID-column) from mytable
re-use the value to insert child records?
Is that correct?
If so, I'd say this will ONLY work properly in a multi-user system if
you're using transactions and you don't commit between the actual
INSERT and SELECT.
It's a pity that MySQL doesn't understand the INSERT INTO ... RETURNING
syntax, as this would solve your problem :-)
Database Workbench - development tool for MySQL, and more!
Database development questions? Check the forum!