Python MySQL AttributeError: 'function' object has no attribute 'execute'

Question

I am trying to retrieve data from tables in MySQL on Python. But I have received

AttributeError: 'function' object has no attribute 'execute'

My code is:

import mysql.connector as sqltor
mycon=sqltor.connect(host="localhost",user="root",passwd=" ",database="revision")
if mycon.is_connected():
    print("Successfully Connected to MySQL database.")
else:
    print("Check yo inputs, they really correct?")

cursor=mycon.cursor
cursor.execute("select*from account")

Output:

Successfully Connected to MySQL database.
Traceback (most recent call last):
  File "C:/Users/biina/Documents/Python/Apparel store/Python/Practical File/Interface_Python_with_MySQL.py", line 10, in <module>
    cursor.execute("select*from account")
AttributeError: 'function' object has no attribute 'execute'

Can you clean up your post a bit? There should be an "edit" button and the interface when asking a question should also explain how to format code, for example. — Lilith-Elina
– Lilith-Elina, Commented Oct 23, 2020 at 13:14
I did not double check the structure after posting so thank you for pointing it out! — I appreciate your help
– I appreciate your help, Commented Oct 23, 2020 at 13:37
Already fixed that for you. Don't know if the changes have been approved already. — n00by0815
– n00by0815, Commented Oct 23, 2020 at 13:38
Hi there, I have approved the suggestion so the post looks perfect from my view, I hope its the same for others. Im new here so thank you for fixing it :) — I appreciate your help
– I appreciate your help, Commented Oct 23, 2020 at 16:04

wind · Accepted Answer · 2020-10-23 13:12:35Z

8

You need to call the cursor function. So replace cursor=mycon.cursor with cursor=mycon.cursor()

answered Oct 23, 2020 at 13:12

wind

2,4592 gold badges12 silver badges31 bronze badges

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

Collectives™ on Stack Overflow

Python MySQL AttributeError: 'function' object has no attribute 'execute'

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related