python连接pymysql数据库报SyntaxError: invalid syntax

Question

代码
import pymysql

user = input("username:")
pwd = input("password:")

conn = pymysql.connect(host="localhost",user='root',password='',database="db666")
cursor = conn.cursor()
sql = "select * from userinfo where username='%s' and password='%s'" %(user,pwd,)

select * from userinfo where username='uu' or 1=1 -- ' and password='%s'

cursor.execute(sql)
result = cursor.fetchone()
cursor.close()
conn.close()

if result:
print('登录成功')
else:
print('登录失败')
运行后报
File "D:/python/untitled1/01.py", line 1, in
import pymysql.cursors
File "D:\python\python-3.5.0-amd64\lib\site-packages\pymysql_init_.py", line 59, in
from . import connections # noqa: E402
File "D:\python\python-3.5.0-amd64\lib\site-packages\pymysql\connections.py", line 206
):
^
SyntaxError: invalid syntax
这是如何处理

Answer 1

这个问题很奇葩 我也遇到了 ，原因就是安装的pymysql 下载的文件语法有误。除了 connections.py 这个文件还有两个文件也有错误。这个connections.py 文件里有两处错误 206行 多了一个逗号 其他错误全是print（f‘XXXXXXXXXX’）报错 去掉那个f 就好了