使用本年度查询上一年和下一年数据

SELECT * FROM sales WHERE YEAR(date) = YEAR(CURRENT_DATE) - 1;

SELECT * FROM sales WHERE YEAR(date) = YEAR(CURRENT_DATE) + 1;

import mysql.connector

# 连接数据库
cnx = mysql.connector.connect(user='username', password='password', host='host', database='database')

# 创建游标
cursor = cnx.cursor()

# 查询上一年数据
query = "SELECT * FROM sales WHERE YEAR(date) = YEAR(CURRENT_DATE) - 1"
cursor.execute(query)
result = cursor.fetchall()

# 输出查询结果
for row in result:
    print(row)

# 查询下一年数据
query = "SELECT * FROM sales WHERE YEAR(date) = YEAR(CURRENT_DATE) + 1"
cursor.execute(query)
result = cursor.fetchall()

# 输出查询结果
for row in result:
    print(row)

# 关闭游标和数据库连接
cursor.close()
cnx.close()