今天发现mysql不认部分delete SQL语句,整理了一下各个数据库中delete from的语法比较
| mysql | derby | oracle | postgresql |
delete from test where id =1 | √ | √ | √ | √ |
delete t from test t where t.id =1 | √ | × | × | × |
delete from test t where t.id =1 | × | √ | √ | √ |