python - 时间戳作为sql查询中的变量

Question

这个问题已经有答案了:

How to use variables in SQL statement in Python? (5 个回答)

已关闭 5 年前。

我想在 python 中使用时间戳值作为 MySQL 查询的变量。

tsmin = 1527573750;
tsmax = 1527574050;
command = "SELECT * FROM #CMD# WHERE data.#CMD#.TimesTamp BETWEEN 
          FROM_UNIXTIME(tsmin) AND FROM_UNIXTIME(tsmax)";

这会出现此错误:_mysql_exceptions.OperationalError:(1054，“'where 子句'中的未知列'tsmin'”)

当我使用以下命令时，它工作正常。

command = "SELECT * FROM #CMD# WHERE data.#CMD#.TimesTamp BETWEEN 
          FROM_UNIXTIME(1527573750) AND FROM_UNIXTIME(1527574050)"

谁能帮帮我？

Answer 1

f 字符串 (Python 3.6+)

tsmin = 1527573750;
tsmax = 1527574050;
command = f"SELECT * FROM #CMD# WHERE data.#CMD#.TimesTamp BETWEEN 
          FROM_UNIXTIME({tsmin}) AND FROM_UNIXTIME({tsmax})";

格式

tsmin = 1527573750;
tsmax = 1527574050;
command = "SELECT * FROM #CMD# WHERE data.#CMD#.TimesTamp BETWEEN 
          FROM_UNIXTIME({tsmin}) AND FROM_UNIXTIME({tsmax})".format(tsmin=tsmin, tsmax=tsmax);