""" Python to MySQL using mysql-python from Sourceforge
at http://prdownloads.sourceforge.net/mysql-python

This is a very simple demonstration of the Python to
MySQL interface downloaded and installed from the above
address.

If you have a database and table already set up for test
purposes, you should be able to adopt this code to work.

"""

import _mysql

db=_mysql.connect(host="192.168.200.66",user="trainee",
                      passwd="abc123",db="forsale")

db.query("""SELECT agent, street, town, phone FROM agents""")
r = db.store_result()

while 1:
    row = r.fetch_row()
    if not row: break
    print row

note = """

Note - issues that may arise:

1. MySQL version dependencies and supported versions.
See distribution for full details but you may need to
        export mysqlclient=mysqlclient
if you don't have the threadsafe libraries.

2. If you have older libraries / newer MySQL, you may
need to set old_password - see link from
http://www.wellho.net/mouth/515_MySQL-an-FAQ.html

3. You need the Python development environment installed
in order to load the MySQL / Python drivers.

4. store_result pulls back the whole result set internally
and you may prefer to call up use_result instead

"""