Python:Read From a Database

From Progzoo
Jump to: navigation, search
Connection parameters
valuedescription
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]