在使用pymysql库执行数据库查询时报错
pymysql.err.OperationalError: (1017, "Can't find file: 'common_1' (errno: 2 - No such file or directory)")
错误的位置为
mycursor.execute(sql)
相关代码
mydb = pymysql.connect(host="localhost", user="root", password="root", db="mydatabase")
mycursor = mydb.cursor()
sql = "select * from " + table_name
mycursor.execute(sql)
result = mycursor.fetchall()
表名为 common_1