Cursor: AttributeError: 'NoneType' object has no attribute 'fetchall'

Question

Code

For a cursor-query:

import mysql.connector
from mysql.connector import errorcode

config = {
    'user': 'root',
    'password': 'root',
    'host': 'localhost',
    'database': 'myDatabase'}


cn = mysql.connector.connect(**config)
cur = cn.cursor()
emailExist = cur.execute("""SELECT * FROM customerDetails""").fetchall()
print(emailExist)

My database file is in the same directory as this script.

AttributeError

I get this error:

>>> emailExist = cur.execute("""SELECT * FROM customerDetails""").fetchall()

>>> AttributeError: 'NoneType' object has no attribute 'fetchall'

Expected

When I run the same query in MySQLWorkbench the output is:

0 row(s) returned

execute doesn’t return anything. Call fetchall on the cursor object itself! — deceze
– deceze ♦, Commented Jan 20, 2020 at 19:31

hc_dev · Accepted Answer · 2023-01-05 19:17:39Z

2

See docs MySQL :: MySQL Connector/Python Developer Guide :: 10.5.6 MySQLCursor.fetchall() Method.

Issue

The error-message

AttributeError: 'NoneType' object has no attribute 'fetchall'

for statement

cur.execute("""SELECT * FROM customerDetails""")

reads:

the execute-statement returned None
and the return value of None doesn't have fetchall attribute or method

Fix

Execute the cursor-methods in this order:

cur.execute(sql) to create the cursor (in cur, not as return)
cur.fetchall() to return the result

edited Jan 5, 2023 at 19:17

hc_dev

9,6941 gold badge30 silver badges47 bronze badges

answered Jan 20, 2020 at 21:31

Xyrus

92810 silver badges13 bronze badges

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

Collectives™ on Stack Overflow

Cursor: AttributeError: 'NoneType' object has no attribute 'fetchall'

Code

AttributeError

Expected

1 Answer 1

Issue

Fix

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

Code

AttributeError

Expected

1 Answer 1

Issue

Fix

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related