本文介绍了DELETE FROM `table` AS `alias` ... WHERE `alias`.`column` ... 为什么语法错误?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着跟版网的小编来一起学习吧！
问题描述
我用 MySQL 试过这个:
I tried this with 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
注意:此查询是自动生成的，条件基于表别名.
Note: This query is automatically generated and conditions are based on table aliases.
为什么会出现这个错误?
Why I get this error?
有没有办法在 where 子句中使用表别名?
Is there any way to use table aliases in where clause?
这是特定于 MySQL 的吗?
Is this MySQL specific?
推荐答案
你可以这样使用 SQL:
You can use SQL like this:
DELETE FROM ContactHostCommand
USING `contact_hostcommands_relation` AS ContactHostCommand
WHERE (ContactHostCommand.`chr_id` = 999999)
LIMIT 1
这篇关于DELETE FROM `table` AS `alias` ... WHERE `alias`.`column` ... 为什么语法错误?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！
本站部分内容来源互联网,如果有图片或者内容侵犯了您的权益，请联系我们，我们会在确认后第一时间进行删除！