我需要帮助取消在mysql中使用PHP删除一行的过程!问题是,我想删除不活跃的帐户,如果他们没有在24小时前活跃!
如何删除:
DELETE FROM members WHERE passkey_valid <= DATE_SUB(NOW(), INTERVAL 1 DAY);
创建一个名为"validated"的列,值为"YES",稍后删除其他列时,以WHERE .... validated !='YES'
为例。
DELETE FROM members WHERE validated !='YES'
AND passkey_valid <= DATE_SUB(NOW(), INTERVAL 1 DAY);
你的INSERT可以像这样:
$validated = "YES";
$query = "INSERT INTO members (validated,date)
VALUES ('$validated', NOW() )";