Re: PB to retrieve ID

Hi, You should use LAST_INSERT_ID() function, check the manual for details: http://www.mysql.com/doc/en/Getting_unique_ID.html Regards Joseph Bueno Poizot Emmanuel wrote: > Hi, > I'm writing a c++ program using MySQL++. > I insert in a table a new line. This table has an autoincrement field ca

PB to retrieve ID

Hi, I'm writing a c++ program using MySQL++. I insert in a table a new line. This table has an autoincrement field call ID. Immediatly after storing a new line in the table, I execute (in the program) a SELECT * FROM table command to retrieve the new ID just affected to the new line, but I alway