我试图比较两个日期时间，它显示sql语法错误
from flask import Flask
from flask import request, jsonify
from datetime import datetime
import pymysql
app = Flask(__name__)
class Database:
def __init__(self):
host = "localhost"
user = "test"
password = "test123"
db = "test"
self.con = pymysql.connect(host=host, user=user, password=password, db=db, cursorclass=pymysql.cursors.DictCursor)
self.cur = self.con.cursor()
@app.route('/getCameraTypeAndTime/<string:date1>/<string:date2>', methods=['GET'])
def getCameraTypeAndTime(date1,date2):
start = datetime.strptime(date1, '%Y-%m-%d %H:%M:%S')
end = datetime.strptime(date2, '%Y-%m-%d %H:%M:%S')
db=Database()
result1=db.cur.execute("Select camera, COUNT(*) as freq from face_log group by camera where timestamp>start and timestamp_end<end")
return jsonify({'result': result1})
if __name__ == '__main__':
app.run(debug=True)
sql中的格式是datetime，但它不会比较
主要问题是，您试图将列值与start和endMySQL关键字进行比较，而不是与start和end变量进行比较。 您需要使用占位符进行查询，并将您的变量像这样传递给它（根据PyMySQL文档）:
db.cur.execute("""
SELECT camera, COUNT(*) AS freq FROM face_log
WHERE timestamp > %s and timestamp_end < %s
GROUP BY camera
""", start, end)
还要注意，SQL查询的group by部分必须在where部分之后。
