Ruby:Read From a Database

Ruby:Top Ten Tips

Hello World

Convert to Number

Read Text File

Sum an Array

Count 0 to 9

Hash Table

Regular Expression

Read Database

Read XML

Define a Class

Connection parameters

value	description
127.0.0.1	the IP address database server;
gisq	the name of the database;
scott	user name;
tiger	the password;

Read the name and population for each country with a population of more than 200000000.

The SQL statement is:

SELECT name, population
FROM bbc
WHERE population>200000000

You can access other columns from the bbc table. The columns are name region area population and gdp.

.

require 'mysql' dbh = Mysql.real_connect("127.0.0.1", "scott", "tiger", "gisq") sql = "SELECT name, population FROM bbc WHERE population>200000000" sth = dbh.query(sql) sth.each do |row| printf "#{row[0]}\t#{row[1]}\n" end

[Font] [Default] [Show] [Resize] [History] [Profile]

test text