您需要按user_id(例如WHERe user_id = 1)过滤表,然后按时间(例如ORDER BY
datetime)对其进行排序,然后将查询限制为一项(例如LIMIT1),然后删除此查询的结果。最后,您将获得如下查询:
DELETe FROM LoginTime WHERe user_id=1 ORDER BY datetime DESC LIMIT 1

您需要按user_id(例如WHERe user_id = 1)过滤表,然后按时间(例如ORDER BY
datetime)对其进行排序,然后将查询限制为一项(例如LIMIT1),然后删除此查询的结果。最后,您将获得如下查询:
DELETe FROM LoginTime WHERe user_id=1 ORDER BY datetime DESC LIMIT 1