auto_increment

[Joachim Person]

How can I handle auto_increments? For instance, having

 

                         user_prescription subscription;

                         subscription.user_id = user_id;

                         subscription.service_id = service_id;

                         query.insert(subscription);

                         query.execute();

 

 

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?