今天发现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 |
× |
√ |
√ |
√ |