Re: last_insert_id() value not updated

2004-06-02 Thread Victoria Reznichenko
"paqogomez" <[EMAIL PROTECTED]> wrote: > I am trying to build a stored procedure in v. 5. > This is what I have so far. > > delimiter | > create procedure get_id(out oid int) > begin >insert into mercury.merchant (name) values(null); >select last_insert_id() into @mid; >insert into mer

last_insert_id() value not updated

2004-05-31 Thread paqogomez
I am trying to build a stored procedure in v. 5. This is what I have so far. delimiter | create procedure get_id(out oid int) begin insert into mercury.merchant (name) values(null); select last_insert_id() into @mid; insert into mercury.customers( address1 ) values (null); select l