mysql、mssql、access中的delete比较

mssql中：

delete from test where id=1 与 delete test where id=1是一样的

mysql中：

只能用delete from test where id =1

否则：

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where id=1 at line 1

同样还要注意一点：

在开发中比如：vb+access中嵌入SQL语句进行删除时，也要写成：delete from test where id=1。不然，也是无法删除的。