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
查这个问题查了半小时 汗 。。。。。