php - UPDATE 查询中没有更新一列

Question

我有这个代码:

$get_season_end_time = $db->query("SELECT `end_times` FROM `seasons` ORDER BY `ID` DESC LIMIT 1")->fetch_assoc();
if (time() > $get_season_end_time['end_times']) {
    $db->query("UPDATE `seasons` SET active='-1', ended='1' ORDER BY `ID` DESC LIMIT 1");
}

由于某种原因，ended 列正在更新，但 active 没有。

有什么建议吗？谢谢!

Answer 1

尝试将列的类型设置为DECIMAL

Standard SQL requires that DECIMAL(5,2) be able to store any value with five digits and two decimals, so values that can be stored in the salary column range from -999.99 to 999.99