Mysql在delete时不支持别名？

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