Open Source Tutorials - Open Source Training
Open source training & tutorials from experienced, passionate people
chrome icon firefox icon ie icon opera icon safari icon Sings in these Browsers
A- A A+
You are here: Home Forum

By A Web Design

Welcome, Guest
Username Password: Remember me
Forgot your password? Forgot your username? Create an account
Open Source Varsity Forum
Open Source Community
MySQL Community

Last insert auto-increment number
(1 viewing) (1) Guest
All your queries regarding
MySQL Installation,
Learning MySQL DBA,
and tonnes more... will be solved in this forum
Reply Topic
New Topic
  • Page:
  • 1
TOPIC:

Last insert auto-increment number

Last insert auto-increment number 1 year, 10 months ago #51

  • dhuruv
  • OFFLINE
  • Senior Boarder
  • Posts: 60
  • Karma: 0
In mysql, How do you find out which auto-increment was assigned on the last insert?
Reply Quote

Re:Last insert auto-increment number 1 year, 10 months ago #59

  • andrew
  • OFFLINE
  • Junior Boarder
  • Posts: 22
  • Karma: 0
SELECT LAST_INSERT_ID() will return the last value assigned by the auto_increment function. Note that you don’t have to specify the table name.
Reply Quote
Reply Topic
New Topic
  • Page:
  • 1
Open Source Varsity Forum
Open Source Community
MySQL Community
Powered by Kunena  Protected by Spam Fighter
Time to create page: 1.40 seconds
Login

Login

OSV Newsletter


Receive HTML?

NOTE: To prevent subscription to the OSV newsletter, uncheck the checkbox above.
Guest Blog for OSV
Free Ebook Download
Free Templates