Perl:Read From a Database

From Progzoo
Revision as of 20:54, 8 January 2008 by Andr3w (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
Change password problem
Connection parameters
valuedescription 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]