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

时间:2021-03-22 18:44:38

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

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