Mysql在delete时不支持别名,我也是醉了

来源:互联网 发布:php location用法 编辑:程序博客网 时间:2024/06/03 00:49

mysql在delete下不能直接像oracle一样使用别名
会产生语法错误

delete  from t_bookmark o where o.bookmark_type = '2'          and o.user_id =123

会报错

[Err] 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 'o where o.bookmark_type = '2'          and o.user_id =123' at line 1

查这个问题查了半小时 汗 。。。。。

0 0