At 20.26 10/09/2002, you wrote: >[sigh] my apologies for this OT post but I'm in a bit of a bind: > >Using mysql, I used to be able to use INSERT INTO..VALUES..SELECT >PK_FIELD to snag the most recently created primary key. However, today, >after a long time, I find that it no longer works. Any suggestions on >how I can get this value?
If I well understood your question: SELECT LAST_INSERT_ID(); But it works only for AUTO_INCREMENT field Bye -------------------------------------------------- FABIO SERRA - faser(at)faser.net PGP available -------------------------------------------------- ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
