mysql - DELETE FROM `table` AS `alias` ... WHERE `alias` .`column` ... 为什么语法错误？

Question

我用 MySQL 试过这个:

DELETE FROM `contact_hostcommands_relation` AS `ContactHostCommand` WHERE (`ContactHostCommand`.`chr_id` = 999999) LIMIT 1

我明白了:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE (`ContactHostCommand`.`chr_id` = 999999) LIMIT 1' at line 1

注意:此查询是自动生成的，条件基于表别名。

为什么会出现这个错误？

有没有办法在where子句中使用表别名？

这是 MySQL 特有的吗？

Answer 1

@Matus 和 @CeesTimmerman 所说的关于 MSSQL 的内容也适用于 MySQL 5.1.73:

delete <alias> from <table> <alias> where <alias>.<field>...