Posted by Feudalac! on 10/24/05 13:20

I have to insert a value into a table and with the new ID i have to
update some other tables.

is there a way to do it like:
insert into table (fields) values(...) and return id of new record

update table set field=id of new record where id=number


for now i
insert into table
read last record from table (order by id desc limit 1)
and then undate other tables with the id given...

something to reduce the number of queryes...


thanks

• Next in forum: Re: MySQL return values
• Prev in forum: How can easily copy a selection op data (structure and data)
• Thread view: MySQL return values

[Reply to this message]