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