Re: Can I get a field when inserting a row?

[Jochen Haeberle]

Hi Tim,

At 9:35 Uhr -0700 16.03.1999, Thimble Smith wrote:
>> I have a table "Items" that has a column ID which is autoincrementing
>> and my primary key. Is there any way to know the ID for a new row to
>> this table?
>
> It's easy to do with the mysql_insert_id() function.  Please do
> read the manual - this is referenced right next to the information
> about auto_increment!

I have found the chapter 17.1.3, thank you for the tip! But I cannot 
make use of this information. If I get this right, this documenting 
the c API, but I am looking for a way to do this using SQL, as I am 
working on a Webproject that offers execution of SQL statements 
through the mySQL Unix socket.

Jochen