Executing MySQL Queries using Python

Question

I'm attempting to run some MySQL queries and output the results in my Python program. I've created this function that is called and the cursor is passed through. However, I am running into a problem where running the below code will always return None / nothing.

Here is what I have:

def showInformation(cursor):
    number_rows = 'SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = "DB"'
    testing = cursor.execute(number_rows)

    print(testing)

When using the cursor object itself, I do not run into any problems:

for row in cursor:
         print(row)

JuniorCompressor · Accepted Answer · 2015-03-23 17:56:03Z

1

I guess you need:

print(cursor.fetchone())

because you are returning only a count and so you expect one row.

Calling execute is not supposed to return anything unless multi=True is specified according to mysql documentation. The programmer can only iterate the cursor like you did, or call fetchone to retrieve one row or call fetchall to retrieve all rows or call fetchmany to retrieve some rows.

edited Mar 23, 2015 at 17:56

answered Mar 23, 2015 at 17:10

JuniorCompressor

20.1k4 gold badges33 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Executing MySQL Queries using Python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related