php - DELETE * FROM TABLE WHERE this=that 不起作用

Question

我不确定为什么这个查询不起作用!此查询是删除用户的帐户:

$query = mysqli_query($connection, "DELETE * FROM users WHERE cookie='$cookie'");

但是，当我用 SELECT 替换 DELETE 时，它起作用了!我的 DELETE 语法有误吗？

Answer 1

使用 DELETE 时不需要 *。就这样

"DELETE FROM users WHERE cookie='$cookie'"