Using python with MySQL

[HMS Surprise]

Greetings,

I need to peform some simple queries via MySQL. Searching the list I
see that folks are accessing it with python. I am very new to python
and pretty new to MySQL too. Would appreciate it if you could point me
to some documentation for accessing MySQL via python. Something of the
"Python and MySQL for Dummies" caliber would be about my speed, but of
course I will be thankful for anything offered.

Thanks,

jvh

[Greg Donald]

Re: Using python with MySQL

On 1 May 2007 12:40:20 -0700, HMS Surprise <john@datavoice int.comwrote:

I need to peform some simple queries via MySQL. Searching the list I
see that folks are accessing it with python. I am very new to python
and pretty new to MySQL too. Would appreciate it if you could point me
to some documentation for accessing MySQL via python. Something of the
"Python and MySQL for Dummies" caliber would be about my speed, but of
course I will be thankful for anything offered.

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

--
Greg Donald

http://destiney.com/

[Shafik]

Re: Using python with MySQL

On May 1, 10:40 pm, HMS Surprise <j...@datavoice int.comwrote:

Greetings,
>
I need to peform some simple queries via MySQL. Searching the list I
see that folks are accessing it with python. I am very new to python
and pretty new to MySQL too. Would appreciate it if you could point me
to some documentation for accessing MySQL via python. Something of the
"Python and MySQL for Dummies" caliber would be about my speed, but of
course I will be thankful for anything offered.
>
Thanks,
>
jvh

hi,
download this module:
http://sourceforge.net/projects/mysql-python
and look at the tutorial here:

http://www.kitebird.com/articles/pydbapi.html

[HMS Surprise]

Re: Using python with MySQL

On May 1, 2:58 pm, "Greg Donald" <gdon...@gmail. comwrote:

On 1 May 2007 12:40:20 -0700, HMS Surprise <j...@datavoice int.comwrote:
>

I need to peform some simple queries via MySQL. Searching the list I
see that folks are accessing it with python. I am very new to python
and pretty new to MySQL too. Would appreciate it if you could point me
to some documentation for accessing MySQL via python. Something of the
"Python and MySQL for Dummies" caliber would be about my speed, but of
course I will be thankful for anything offered.

>

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

>
--
Greg Donaldhttp://destiney.com/

Most excellent!

Many thanks, Greg. I'll get started reading pronto.


jvh

[HMS Surprise]

Re: Using python with MySQL

hi,
download this module:http://sourceforge.net/projects/mysql-python
and look at the tutorial here:http://www.kitebird.com/articles/pydbapi.html

Done, thank you too.

jh

[hlubenow]

Re: Using python with MySQL

HMS Surprise wrote:

Greetings,
>
I need to peform some simple queries via MySQL. Searching the list I
see that folks are accessing it with python. I am very new to python
and pretty new to MySQL too. Would appreciate it if you could point me
to some documentation for accessing MySQL via python. Something of the
"Python and MySQL for Dummies" caliber would be about my speed, but of
course I will be thankful for anything offered.
>
Thanks,
>
jvh

There's even another approach:
If you're on Linux, Qt3 may be available. Install its Python-bindings. Given
a database "MyDatabase ", with password "MyPassword " for user "root" and
inside the database a table "MyTable", you can then do something like this:

----------------------------------------------------
#!/usr/bin/env python

from qt import *
import sys
from qtsql import QSqlDatabase, QSqlQuery

app = QApplication(sy s.argv)

DB = QSqlDatabase("Q MYSQL3", "MyDatabase ", app)

DB.setDatabaseN ame("MyDatabase ")
DB.setUserName( "root")
DB.setPassword( "MyPassword ")
DB.setHostName( "localhost" )
DB.open()

c = DB.execStatemen t("select * from MyTable")

while c.next():
print c.value(0).toSt ring()
print c.value(1).toSt ring()
print c.value(2).toSt ring()
print c.value(3).toSt ring()
c.first()

c2 = DB.execStatemen t("select count(*) from MyTable")
c2.next()

print c2.value(0).toS tring()
----------------------------------------------------

Some further documentation:

http://www.arl.hpc.mil/ice/Manuals/PyQt/t1.html

http://doc.trolltech.com/4.2/database.html

H.

[hlubenow]

Re: Using python with MySQL

hlubenow wrote:

There's even another approach: ...

On the other hand you may be better off with the "mysql-python"-module.

Anyway, here's a nice overview over the most commonly used MySQL-commands
(The commands should speak for themselves, even if the explanations are in
German):

http://www.linux-club.de/ftopic49585.html

H.