vb无客户端连接oracle 求ACCESS数据库的增删改语句?

求ACCESS数据库的增删改语句?例如,在表s中,有两个字段,ID和name,ID是数字,name是文本add:insert into s(ID,name)values(1,“Zhang San”de

求ACCESS数据库的增删改语句?

例如,在表s中,有两个字段,ID和name,ID是数字,name是文本

add:insert into s(ID,name)values(1,“Zhang San”

delete:delete from S

delete from S

delete from S where id=1

delete from S where id=1

delete from S where id=1

delete from S where Name=“Zhang San”

change:例如,将id为1的人的名字改为Li Si

更新S set Name=“Li Si”where id=1基本上就是这样。如果你有任何问题,再问一次