List:MySQL++« Previous MessageNext Message »
From:Chris Frey Date:March 14 2005 8:47pm
Subject:Re: auto_increment
View as plain text  
On Mon, Mar 14, 2005 at 08:35:27PM +0100, Joachim Person wrote:
> and subscription also has a "id" field which is auto_increment, doesn't
> work. The id field gets some seemingly random value. How can I make sure
> auto_increment works?

auto_increment happens at the database level.  I don't believe mysql++
automatically updates the struct with the new id, you need to get it yourself
with the insert_id() call.

	query.store();
	int id = connection.insert_id();// do this right after the
					// insert operation

- Chris

Thread
auto_incrementJoachim Person14 Mar
  • Re: auto_incrementChris Frey14 Mar
    • Re: auto_incrementEarl Miles14 Mar
      • Re: auto_incrementChris Frey15 Mar
        • sql_create in headerdon thompson7 Apr
          • Re: sql_create in headerWarren Young8 Apr
            • Re: sql_create in headerdon thompson8 Apr
          • Re: sql_create in headerWarren Young9 Apr
  • Re: auto_incrementWarren Young15 Mar
    • Re: auto_incrementWarren Young15 Mar