> Fair enough. I suspected that might be the case but I can rewrite the
> SQL such that auto_increment is unnecessary and therefore I will do
> that; I just thought that I would ask anyway just incase. And I might
> even go try and find what Joe Celko said on the topic.
You might also be interested in similar threads on this mailing list
that dealt with the same question and the related question of
get_affected_rows() of the last insert/update. Just search the
archive for get_affected_rows and last_insert_id.
Joe Celko is the author of several books on SQL and has a rather
strong opinion on integer ids in general and auto_increment values
in particular. I find myself disagreeing with his general dislike of
integer ids but agreeing with the auto_increment part. In any case,
he may have more elabourate reasons on offer than me ;-)
best regards,
Sören
------------------------------------------------------------------------------
The Planet: dedicated and managed hosting, cloud storage, colocation
Stay online with enterprise data centers and the best network in the business
Choose flexible plans and management services without long-term contracts
Personal 24x7 support from experience hosting pros just a phone call away.
http://p.sf.net/sfu/theplanet-com
_______________________________________________
Soci-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/soci-users
