Perl:Read From a Database
From Progzoo
Read 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]