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。不然,也是无法删除的。
转载于:https://blog.51cto.com/sqlnet/130244