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