我可以帮助理解python SQL查询中的语法错误吗?

2024-03-29 08:53:14 发布

您现在位置:Python中文网/ 问答频道 /正文

我是编程新手,正在尝试理解如何从SQLLite中划出一条信息线,其中唯一的因素恰好是用户名

import sqlite3

conn=sqlite3.connect("customer database.db")

#line 7 and 9 needed to connect sql database in between
#will show the lines of information they want retrieve
cursor=conn.cursor()
#is just necessary step
userlogin=input("please login")


#line of logic does not compute to python but works directly in SQL
sqlgetcus = f"SELECT * FROM Customer WHERE username is "{userlogin}""


cursor.execute(sqlgetcus)

row=cursor.fetchone()
assert row[0]== userlogin


print(row)

1条回答
网友
1楼 · 发布于 2024-03-29 08:53:14

无法真正测试其余部分,但我认为这就是问题所在: 你写道:

f"SELECT * FROM Customer WHERE username is "{userlogin}""

但你真正想做的是:

f"SELECT * FROM Customer WHERE username is {userlogin}"
## OR
"SELECT * FROM Customer WHERE username is {}".format(userlogin)

相关问题 更多 >