尝试将 python 输入命令插入我的 SQL 查询

Question

所以这就是我想要做的我只想知道是否有办法将日期输入命令链接到我的 SQL 查询，以便运行代码的任何人都可以输入日期并仅获取该特定日期的信息。（这里是超级傻瓜）

date = input("DATE:YYYY-MM-DD")

query = '''

SELECT timestamp , something , someotherthing 

FROM database

WHERE timestamp = date

'''

pd.read_sql_query(query,con)

Answer 1

要获得要推荐的输入的日期，您可以格式化您的字符串date = input("DATE:YYYY-MM-DD")query = '''SELECT timestamp , something , someotherthing FROM databaseWHERE timestamp = {date}'''pd.read_sql_query(query.format(date=date),con)或没有日期参数date = input("DATE:YYYY-MM-DD")query = '''SELECT timestamp , something , someotherthing FROM databaseWHERE timestamp = {}'''pd.read_sql_query(query.format(date),con)

Answer 2

连接字符串。date = input("DATE:YYYY-MM-DD")query = "SELECT timestamp , something , someotherthing \FROM database \WHERE timestamp = " + str(date)pd.read_sql_query(query,con)