求ACCESS數(shù)據(jù)庫(kù)的增刪改語(yǔ)句？例如，在表s中，有兩個(gè)字段，ID和name，ID是數(shù)字，name是文本add:insert into s（ID，name）values（1，“Zhang San”de

求ACCESS數(shù)據(jù)庫(kù)的增刪改語(yǔ)句？

例如，在表s中，有兩個(gè)字段，ID和name，ID是數(shù)字，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的人的名字改為L(zhǎng)i Si

更新S set Name=“Li Si”where id=1基本上就是這樣。如果你有任何問(wèn)題，再問(wèn)一次