Guest User

Untitled

a guest
Aug 15th, 2018
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.44 KB | None | 0 0
  1. require 'rubygems'
  2. require 'mysql'
  3.  
  4. db = Mysql.connect('localhost', 'root', 'password', 'test')
  5.  
  6. # Maak een query die gegevens opzoekt:
  7. begin
  8. query = db.query('select name,city from customers')
  9. puts "There are #{query.num_rows} records found .."
  10. query.each do |rec|
  11. puts rec.inspect
  12. puts rec[0],rec[1],rec[2]
  13. end
  14. rescue
  15. puts db.errno
  16. puts db.error
  17. ensure
  18. # Close databaseconnection
  19. db.close if db
  20. end
Add Comment
Please, Sign In to add comment