Executing Select statement by using mysql-python gives None

Question

I am using python-2.7 and newbie to mysql/mysql-python connector.

I just want to retrieve data simply by using following query-

SELECT d_id,d_link,d_name FROM d_details

But it gives/returns None . Following is my code-

def getdbconnection(self):

    try:

        self.cnx = mysql.connector.connect(user='abc',password='xxx',host = 'localhost',port = 'xxx', database='details',buffered=True)      

        print "Done"
        self.cursor = self.cnx.cursor()

    except MySQLdb.Error as error:      
                print "ERROR IN CONNECTION"

def selectst(self):
        try:
                    print "S E L E C T"
                    self.d_deta = self.cursor.execute("SELECT d_id,d_link,d_name FROM `d_details`")
                    print self.d_deta


        except MySQLdb.Error as error:
                            print "---------------------"""
                            print(error)
        self.cnx.commit()

AND the output is

   Done

    S E L E C T

    None

Although query works well in workbench

Help/guidance in any form is welcome.

try print self.cursor.fetchall()

The6thSense
– The6thSense

2015-12-15 06:39:28 +00:00
Commented Dec 15, 2015 at 6:39 — The6thSense
– The6thSense, Commented Dec 15, 2015 at 6:39
@VigneshKalai - Thanks a lot that works well !

Pallavi Joshi
– Pallavi Joshi

2015-12-15 06:55:43 +00:00
Commented Dec 15, 2015 at 6:55 — Pallavi Joshi
– Pallavi Joshi, Commented Dec 15, 2015 at 6:55

The6thSense · Accepted Answer · 2015-12-15 06:50:33Z

1

You should modify your code like this

Code:

def selectst(self):
    try:
          print "S E L E C T"
          self.cursor.execute("SELECT d_id,d_link,d_name FROM `d_details`")
          print  self.cursor.fetchall() # or fetchone() for one record

    except MySQLdb.Error as error:
                        print "---------------------"""
                        print(error)
    #self.cnx.commit() there is no need of commit here since we are not changing the data of the table

Notes:

You get None because cursor.execute is a in memory operation like list.sort()
The row can be got by iterating over the cursor object or using fetch*()

answered Dec 15, 2015 at 6:50

The6thSense

8,3559 gold badges38 silver badges67 bronze badges

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

Collectives™ on Stack Overflow

Executing Select statement by using mysql-python gives None

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