How to retrieve an auto-increment ID of a row
From: David Lee <pritino2020_at_yahoo.com.tw>
Date: Tue, 4 Sep 2001 20:51:55 +0800
Message-ID: <9n2i8l$2jsjf$1_at_news.shem.etwebs.com>
[Quoted] [Quoted] After I inserted a row of data, how do I retrieve the auto-increment ID of this row ? Because there might be another SQL script also inserting into this table at the same time, it is not guaranteed that I will get the correct ID by selecting right after inserting. Is there a function for this? Thousands of appreciation!!!
Date: Tue, 4 Sep 2001 20:51:55 +0800
Message-ID: <9n2i8l$2jsjf$1_at_news.shem.etwebs.com>
[Quoted] [Quoted] After I inserted a row of data, how do I retrieve the auto-increment ID of this row ? Because there might be another SQL script also inserting into this table at the same time, it is not guaranteed that I will get the correct ID by selecting right after inserting. Is there a function for this? Thousands of appreciation!!!
[Quoted] Please tell me where I should post this question if I post the wrong newsgroup, thanks!! Received on Tue Sep 04 2001 - 14:51:55 CEST