» Quick Links
You can make money on these forums
We Share profits with you
Google
Google Adsense
Google Adwords
YPN
Yahoo
MSN Search
Web Directories
Web Hosting
Web Hosting Offers
Hosting News
Suggestions
Link Building
Domain Names
PHP Forums
MySQL Forums
» More Links
OSP News
Reseller Hosting
Shared Hosting
Dedicated Servers
Google Adsense
Search Engine Marketing
Link Development
Affiliate Marketing


» Advertising
Multiple DC PR Check

Free SEO Tools


Go Back   Webmaster Forums > Website Developement / Programming > MySQL Forums

MySQL Forums Share Your Ideas and Tips about MYSQL. Ask questions about MYSQL. Table Design and Much More...

Reply
 
Thread Tools Display Modes
  #1  
Old 05-25-2007, 02:42 AM
gazel gazel is offline
Junior Member
 
Join Date: May 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
gazel is on a distinguished road
Default retrieving auto-inc ID value?

Hi all of you,
I'm using MySQLdb in python to insert a row into a table with an auto-inc ID field. I wanna use the auto-inc feature, but can't figure out how to retrieve the value of 'ID' which has been assigned after the row has been inserted. Please share your thoughts?
Thank you in advance. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote
Revenue Sharing Ads ( ?):
  #2  
Old 05-25-2007, 07:08 AM
Saggie Saggie is offline
Senior Member
 
Join Date: Jul 2006
Posts: 155
Thanks: 0
Thanked 1 Time in 1 Post
Rep Power: 17
Saggie is on a distinguished road
Default Re: retrieving auto-inc ID value?

You might need last_insert_id(). -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
retrieving date and time???? Prett MySQL Forums 1 10-28-2006 04:53 AM
How to get the Next Auto Increment number +Mysql Mclaren PHP Programming and Tips 1 08-25-2006 09:55 AM
vbscript - auto hyperlink words in content that exist in DB messiah ASP forums and Tips 2 08-23-2006 02:04 PM
how to create auto responder in ASP?? illingworth ASP forums and Tips 1 08-22-2006 02:12 PM
auto increment!! Dael MySQL Forums 1 08-08-2006 07:51 AM


All times are GMT. The time now is 03:02 AM.