MySQL DELETE 表别名问题

oracle中可以使用：
DELETE FROM TABLE T WHERE T.ID = ##

但在mysql中会报语法错误
要么不使用别名，要么更改写法为
DELETE T FROM TABLE AS T WHERE T.ID = ##
或者
DELETE FROM T USING TABLE AS T WHERE T,ID = ##