开发者社区> 问答> 正文

python 查询mysql,报错?报错

python 查询mysql报错

Traceback (most recent call last):
  File "D:/Python27/a.py", line 16, in <module>
    cursor.execute('SELECT  1 FROM TB_AREA')
  File "c:\users\zhangfp\appdata\local\temp\easy_install-opvywq\MySQL_python-1.2.5-py2.7-win32.egg.tmp\MySQLdb\cursors.py", line 205, in execute
    self.errorhandler(self, exc, value)
  File "c:\users\zhangfp\appdata\local\temp\easy_install-opvywq\MySQL_python-1.2.5-py2.7-win32.egg.tmp\MySQLdb\connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
OperationalError: (1046, 'No database selected')

源码是:

#mysqldb      
import  MySQLdb   
          
#connect   
conn=MySQLdb.connect(host="localhost",user="root",passwd="123456")    
cursor = conn.cursor()      
          
cursor.execute('SELECT  1 FROM TB_AREA')
conn.close()  

展开
收起
爱吃鱼的程序员 2020-06-10 10:55:48 632 0
1 条回答
写回答
取消 提交回答
  • https://developer.aliyun.com/profile/5yerqm5bn5yqg?spm=a2c6h.12873639.0.0.6eae304abcjaIB

    <spanstyle="font-family:Verdana,sans-serif,宋体;font-size:14px;line-height:22px;background-color:#FFFFFF;">OperationalError:(1046,'Nodatabaseselected')没指定用哪个库,怎么查表pythoneepd如何安装第三方库,现在先要安装MySQLdb。但是不知道怎么装,和正常情况下一样吗。系统是win7搞定了,谢谢哈

    2020-06-10 10:56:04
    赞同 展开评论 打赏
问答排行榜
最热
最新

相关电子书

更多
From Python Scikit-Learn to Sc 立即下载
Data Pre-Processing in Python: 立即下载
双剑合璧-Python和大数据计算平台的结合 立即下载