我正在使用python-2.7和newbie-to-mysql/mysql python连接器。在
我只想通过以下查询检索数据-
从d_details中选择d\u id、d\u link、d\u name
但它给出/返回无。以下是我的密码-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()
输出是
^{pr2}$
尽管查询在workbench中运行良好
欢迎任何形式的帮助/指导。在