MySQL SHOW TABLE STATUS results

require ‘rubygems’
require ‘Mysql’

db = Mysql.connect(‘localhost’, ‘mysql’, ‘*****’, ‘auto_reorder’)
query = db.query(“SHOW TABLE STATUS FROM auto_reorder LIKE
‘customers’;”)

I’m trying to parse the results and get the Auto_increment. Any help is
appreciated