require "dbi" dbh = DBI.connect("dbi:Mysql:test:localhost", "root", "P@ssW0rd") sth = dbh.prepare("SELECT 'Hello, DBI World' AS Message") sth.execute() while row = sth.fetch do print "Message", "n"; print "-------------------n"; print row[0] end sth.finish dbh.disconnect