试图在SQL中插入python,但出现了一个错误: OperationalError:近"02":语法错误
import sqlite3
conn=sqlite3.connect("Date_time3.db")
print("Database Opened successfully")
conn.execute("""
CREATE TABLE ADMIN(
EXPIRE DATETIME PRIMARY KEY
)
""")
这是我的数据库^
import datetime
import pytz
import sqlite3
today = datetime.datetime.now()
date_time = today.strftime("%m/%d/%Y, %H:%M:%S")
conn=sqlite3.connect("Date_time3.db")
print("Database Opened successfully")
conn.execute("INSERT INTO ADMIN(EXPIRE) VALUES " +date_time);
conn.commit()
print ("Records inserted successfully")
conn.close()
"""
###Output###
#Database Opened successfully
#Records inserted successfully
#"""
print ("Table ADMIN created successfully")
"""
####Output###
Database Opened successfully
Table ADMIN created successfully
"""
发布于 2022-02-10 23:21:04
改变这一点:
conn.execute("INSERT INTO ADMIN(EXPIRE) VALUES " +date_time);
至
conn.execute('INSERT INTO ADMIN(EXPIRE) VALUES (?)', [date_time]);
在运行SQL命令时,它们的工作方式与Python不同。因此您不能使用+
运算符。您需要使用像(?)
这样的占位符
https://stackoverflow.com/questions/71076375
复制