Mysql in Python?

[Jeremy Jones]

Stefan Stolz wrote:

>Hello,
>i tried to find something about mysql in www.python.org, but found
>nothing...
>What can you recommend to use for getting and putting data from and into a
>mysql database?
>On my Suse 9.1 i found a rpm python-mysql. In the web i found the hk_classes
>from www.knoda.org. This should do also such things.
>Can you recommend something? What do you use?
>Thank you very much for the info.
>  
>
I have used a MySQLdb module before.  Here's a piece of code that I 
found lying around my home directory:

import MySQLdb

if __name__ == "__main__":
    db_conn = 
MySQLdb.connect(host='hostname',db='database_name',user='username',passwd='password')
    handle = db_conn.cursor()
    query = "SELECT * FROM foo"
    handle.execute(query)
    Results = handle.fetchall()
    print Results

I'm not sure, but I believe that MySQLdb is included in this project:

http://sourceforge.net/projects/mysql-python

(which appears to have been updated only a couple of months back, so 
that's good news).