Blog » Blog Entry

Live Search:

Get the next MySQL auto_increment id using ActiveRecord

May 22, 2008

I see this come up on the Rails list from time to time, so I figured I'd document it here as a blog entry.

To get the next auto_increment id from a MySQL table using ActiveRecord:

@next = ActiveRecord::Base.connection.execute( "
  SELECT auto_increment
  FROM information_schema.tables
  WHERE table_name='foo'
" ).fetch_hash['auto_increment'].to_i

Tags:

rubyonrails, mysql

« VirtualBox "no workie" after kernel upgrade

Simple git setup for new git users »

Also...

By: Gabe <gabe at websaviour dot com>

Posted: 1 year ago

If you have more than one database with that table you will need to specify the database name as a table_schema='bar' clause.

Book Recommendation:

Agile Web Development with Rails is the defacto-standard for learning the Ruby on Rails web framework. Now in its second edition, this book provides knowledge of the latest and greatest development techniques to aid in advanced web-based application development. It enables developers to create full-featured, sophisticated applications using less code and less effort. This book contains sample applications using database migrations, Ajax, REST interfaces, and illustrates many new Rails features. There are new chapters on active support, active record, and action controller (including the new resources-based routing). The web 2.0 and deployment chapters appear to have been completely rewritten to reflect the latest thinking. You can learn which environments are best for your style application, and see how Capistrano makes managing your site really simple. For learning Ruby on Rails, this book is simply the best available.

Recent Blogs:

Blogs Archive:

2010(2)
- February(1)
- January(1)
2009(14)
- November(1)
- September(2)
- August(3)
- June(1)
- May(3)
- April(1)
- January(3)
2008(76)
- December(1)
- November(2)
- October(2)
- September(5)
- August(2)
- July(4)
- June(4)
- May(16)
- April(7)
- March(2)
- February(1)
- January(30)
2007(37)
- December(5)
- November(2)
- October(2)
- September(2)
- August(2)
- June(9)
- May(4)
- March(2)
- February(2)
- January(7)
2006(32)
- December(3)
- November(4)
- October(8)
- September(1)
- August(1)
- July(2)
- May(13)

Random Quote:

Perfection (in design) is achieved not when there is nothing more to add, but rather when there is nothing more to take away.

~Antoine de Saint-Exup'ry