From: Sean Chittenden <sean@...>
Date: 2002-05-21T03:27:06+09:00
Subject: Re: DBI access to mysql auto_increment record numbers?

> How do you get the auto_increment record number for mysql in 
> ruby/dbi/mysql?

sql = 'INSERT INTO foo (foo_name) VALUES (?)'
dbh.do(sql, my_foo_name)
insert_id = dbh.insert_id

if insert_id.nil?
  raise "bad things happened"
end

It's untested... but DBD::Mysql#insert_id() should be available via a
DBH instance.  -sc

-- 
Sean Chittenden