tags:

views:

37

answers:

0

Hello

I've got some problems with a script I'm writing.

#!/usr/local/bin/python

import MySQLdb

ConvDB = MySQLdb.Connect(host="1.1.1.1", user="123", passwd="123", db="somedb")
ConvDBcursor = ConvDB.cursor()

query="SELECT id from sometable WHERE somethng=63"
print query
ConvDBcursor.execute(query.decode('cp1251').encode('utf8'))
print ConvDBcursor.rowcount
ConvDBcursor.close()
ConvDB.close()

It returns something like

1
((18L,),)

But there's no records in sometable at all! Is it a bug, or I just do something wrong?

PS I'm using python 2.6.3, mysqldb 1.2.3c1 on Win7