MySQL5.5 /phpmyadmin简单查询之谜

Question

如果我在我的PhpMyAdmin (4.0.5版)上运行这个select-query：

(SELECT *
FROM prenotazione
WHERE stato = 'prenotato'
AND (to_days( data ) +2) < to_days( NOW( ) )
)

这运行得很好。

但是如果我运行一个不起作用的delete-query：

(DELETE *
FROM prenotazione
WHERE stato = 'prenotato'
AND (to_days( data ) +2) < to_days( NOW( ) )
)

请解释一下，为什么会发生这样的事情。

Answer 1

只是

DELETE FROM ...

不

DELETE * FROM ...
      ^^^

有关更多信息，请参阅DELETE Syntax

Answer 2

如下所示进行查询：

(DELETE FROM prenotazione WHERE stato = 'prenotato' AND (to_days( data ) +2) < to_days( NOW( ) ) )

有关详细信息，请查看delete语法manual

Answer 3

这项工作在查询前后使用*和圆括号

DELETE
FROM prenotazione
WHERE stato = 'prenotato'
AND (to_days( data ) +2) < to_days( NOW( ) )