Ruby:Read From a Database
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
.
[Font]
[Default]
[Show]
[Resize]
[History]
[Profile]