Suppress cursor.execute() message in python MySQLdb

Question

How to suppress the cursor.execute() message in MySQLdb.

>>> from warnings import filterwarnings
>>> import MySQLdb
>>> filterwarnings('ignore', category = MySQLdb.Warning)
>>> db = MySQLdb.connect('127.0.0.1', 'root', '','')
>>> cursor = db.cursor()
>>> cursor.execute("select version()")
1L

I need to suppress this '1L' message

I am looping through a text file and inserting each record in the mysql table. For each cursor.execute(), I am getting this value, which is annoying in my case. But assigning to a variable may be a good idea. — Curious
– Curious, Commented Nov 6, 2012 at 16:55

Martijn Pieters · Accepted Answer · 2012-11-06 17:15:53Z

1

What you see there is not a warning message, but the return value of cursor.execute(). It's the number of rows affected, 1.

The API happens to return a Python long integer, but it's otherwise the same as a regular int value:

>>> 1L
1L
>>> 1
1
>>> 1 == 1L
True

If you do not want the Python console to echo return values back to you, assign them to a variable:

>>> somevariable = 1L

edited Nov 6, 2012 at 17:15

answered Nov 6, 2012 at 16:37

Martijn Pieters

1.1m326 gold badges4.2k silver badges3.4k bronze badges

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

Collectives™ on Stack Overflow

Suppress cursor.execute() message in python MySQLdb

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