Question

SQL中，delete与delete from有区别吗？

delete from Sheet1 where sheet1.to_mobile in (select to_mobile from Sheet2)

delete Sheet1 where sheet1.to_mobile in (select to_mobile from Sheet2)

这两句效果一样哦

Answer 1

有区别，如果是单个表和使用in则没有区别，如果使用where a.id=b.id 就必须用from
例如 delete a from table1 a , table2 b
where a.id=b.id

Answer 2

严格的说应该是要有from的
其实是省略了from

Answer 3

没区别。