我正在尝试将从用户收到的变量值插入到表中:
try:
# create table
with connection.cursor() as cursor:
role = "user"
version = 0
dol = 0
#insert_query = "INSERT INTO `DataBaseRegAndLog` ('user', 'pass', 'role', 'version', 'email', 'dol') VALUES (%s, %s, %s, %s, %s, %s);"
cursor.execute("INSERT INTO `DataBaseRegAndLog` ('user', 'pass', 'role', 'version', 'email', 'dol') VALUES (%s, %s, %s, %s, %s, %s)", (loginUser, passUser, role, version, emailUser, dol))
connection.commit()
finally:
connection.close()
except Exception as ex:
print("Connection refused...")
print(ex)
但它给了我错误 1064:
C:\Users\Demon\PycharmProjects\tg_DemonDostavka\.venv\Scripts\python.exe C:\Users\Demon\PycharmProjects\tg_DemonDostavka\main.py
successfully connected...
####################
Connection refused...
(1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''user', 'pass', 'role', 'version', 'email', 'dol') VALUES ('/reg', '/reg', 'user' at line 1")
我首先尝试将sql命令注册在一个单独的变量中,但它给出了一个错误。现在我知道一行中有一条sql命令和变量。
将字段名称的引号更改为 `
' 字符用于指示字符串,例如:
亚马逊|姓名
野啤酒是的|姓名
奥尊 |姓名