MySQL Delete语句不能用别名

正常情况下mysql删除语句不能用别名,如果要用别名需要把别名写再Delete后：

SQL:
DELETE t from table t
where t.order_id = "123";