SELECT statement is MySql returning wrong value using python

Question

I am trying to retrieve a value from a table stored in Mysql database using python(pycharm). But instead of outputting the stored value it outputs number of rows instead.

import pymysql
connection = pymysql.connect(host='localhost',
                             user='root',
                             password='passw',
                             database='database1',
                             charset='utf8',
                             port=3306
                             )
x=connection.cursor()
select = x.execute('''SELECT
    update_id
FROM
    telegram;
''')
print(select)

Output: 1

^Wrong output(Output equals number of rows). As I keep adding on rows the output changes to the number of rows but never returns the value stored.

The command works from MySql perfectly.

SELECT
        update_id
    FROM
        telegram;
Output:233

^This is the correct output. Why is this happening? What changes should I make in my python code?

Yes sir , The UPDATE command works using python on the same database and table. — pundit
– pundit, Commented May 28, 2020 at 13:10

Akib Rhast · Accepted Answer · 2020-05-28 13:14:02Z

1

According to the documentation on pymysql, this is how you are supposed to do the print out:

    sql = "SELECT `id`, `password` FROM `users` WHERE `email`=%s"
    cursor.execute(sql, ('[email protected]',))
    result = cursor.fetchone()
    print(result)

You are missing "cursor.fetchone()"

I hope that helps

answered May 28, 2020 at 13:14

Akib Rhast

6714 silver badges17 bronze badges

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

Comments

Steve · Accepted Answer · 2020-05-28 13:16:01Z

0

According to the documentation, cursor.execute() returns the number of affected rows. You then need to fetch the content with fetch() or fetchall(). See the example at PyMySQL.

answered May 28, 2020 at 13:16

Steve

7164 silver badges10 bronze badges

1 Comment

Steve Over a year ago

If you find one of the answers satisfactory, mark that answer "accepted" with the check mark. It helps both you and me!

Collectives™ on Stack Overflow

SELECT statement is MySql returning wrong value using python

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related