Mysql in Python?

[Stefan Stolz]

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.

 

[Jeremy Jones]

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).

 

[Stefan Stolz]

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).

Thank you, but i don`t understand why there is nothing implemented in
Python?

I was a little konfused after reading the doku of mysql-python, because
there the author says its better to use MySQLdb ;-) ?!?!

 

[Jeremy Jones]

Jeremy Jones wrote:



Thank you, but i don`t understand why there is nothing implemented in
Python?

I was a little konfused after reading the doku of mysql-python, because
there the author says its better to use MySQLdb ;-) ?!?!

So, are you wanting a pure Python module to connect to MySQL? I'm not
sure there are any that exist.

Jeremy

 

[Yann.K]

So, are you wanting a pure Python module to connect to MySQL? I'm not
sure there are any that exist.

10 seconds with google and maybe some leads:
http://www.hk8.org/old_web/linux/sql/ch11_01.htm
http://mysql.mirror.nedlinux.nl/downloads/python.html
http://linux.maruhn.com/sec/mysql-python.html
http://linux.com.hk/docs/mysql/manual_Clients.html#IDX2125

HTH.