Tagged Questions

0
votes
2answers
67 views

How do I check why my INSERT query is not working?

conn = MySQLdb.connect(host=IP,user='john',passwd='ab2nng',db='mydb') cursor = conn.cursor() #this works. cursor.execute("select * from crawl_log") res = cursor.fetchall() print res #this doesn't ...
0
votes
1answer
62 views

Python | MySQLdb -> I cant insert

I have an odd problem. There are two databases. One has all products in it for an online shop. The other one has the online-shop software on it and only the active products. I want to take the values ...
1
vote
1answer
51 views

MySQLdb and big queries using CursorUseResultMixIn

How can I use the CursorUseResultMixIn in MySQLdb. The obvious thing to do was: con=MySQLdb.connect(host='localhost', user='test', passwd='xx', db='yy') curs = ...
0
votes
1answer
76 views

Unable to connect to Database using MySQLdb in Robotframework

Using Robotframework 2.6.3 and the python database library, I want to connect to MySql Database. I have downloaded the DatabaseLibrary and MySQLdb however when I try to connect using: Library ...
1
vote
2answers
41 views

How to know if it is unsigned of a field from mysql by MySQLdb

I use MySQLdb(a python library) to talk with mysql. Is there some way to get the field type using MySQLdb , and the most important thing is how can I know it is unsigned or not ? I know we can use ...
1
vote
4answers
120 views

Python MYSQLdb documentation missing details?

I am trying to make sense of MySQLdb documentation. I was just wondering if there are things missing from there. For example, I am trying to see what "rowcount" (a constant) actually does, but am not ...
-3
votes
1answer
78 views

two database connection with Mysqldb in python

Can any body please let me know if more than one database connection at a time is possible with Mysqldb in python script. I have a scenario where i want to query from databaseA tables (which can be ...
2
votes
2answers
117 views

Proper way to establish database connection in python

I have a script with several functions that all need to make database calls. I'm trying to get better at writing clean code rather than just throwing together scripts with horrible style. What is ...