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 »

Book Recommendation:

The C++ Programming Language is the defacto-standard for C++. Written by Bjarne Stroustrup, the creator of C++, this book presents the full specification for the C++ language and standard library, a spec that will soon become the joint ISO/ANSI C++ standard. This is not really a C++ language tutorial but instead provides a clear presentation of all its elements. It is impossible to overstate the importance of this book for anyone who is serious about using C++. This book is in no way thin on material for the intermediate to advanced C++ software engineer.

Recent Blogs:

Random Quote:

The invisible and the non-existent look very much alike.

~Delos B. McKown