mysql 多重删除错误

Question

我有mysql查询

DELETE data 
    FROM table 
        WHERE DATE_SUB(NOW(), INTERVAL 1 DAY) 
            AND status <> 0;

我收到此错误:

ERROR 1109 (42S02) at line 2: Unknown table 'date' in MULTI DELETE

如何解决这个问题？

Answer 1

data 未定义。您可以使用别名或将其完全删除:

DELETE t 
    FROM table t
    WHERE DATE_SUB(NOW(), INTERVAL 1 DAY) AND status <> 0;

或者尝试一下:

DELETE FROM data
    WHERE DATE_SUB(NOW(), INTERVAL 1 DAY) AND status <> 0;