Skip to content

Instantly share code, notes, and snippets.

@xianhuazhou

xianhuazhou/gist:1351213

Created November 9, 2011 11:48
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save xianhuazhou/1351213 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save xianhuazhou/1351213 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.rb
require 'mysql'
db = Mysql.new('webdb', 'root', 'pa$$', 'home')
db.query("SHOW TABLES LIKE '%home%'").each do |row|
tb_status = db.query("CHECK TABLE #{row[0]}").fetch_row
puts tb_status.join("\t")
end
db.close
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment