insert into stu(number,name,sex,birthday,height,age) values("000111","JIM",.t.,{^1981-01-03},1.77,23)

VFP不支持追加插入，可以在Access中进行追加插入 INSERT INTO stu1 SELECT * FROM stu WHERE sex=true INSERT INTO stu2 SELECT * FROM stu WHERE number not in ( SELECT number FROM stu1)

delete from stu where sex=.f. delete from stu1 where number in (select number from stu2)

update stu1 set name="Jim" where number="000111" update stu1 set name="Jim" update grade set grade=grade+1 where number=(select number from stu where name="赵怡春")

其他的操纵语句 SELECT stu.number INTO stu12 FROM stu

SQL Server： insert into stu(number,name,sex,birthday,height) values(\'000111\',\'JIM\',1,\'1981-01-03\',1.77)

select * into stu1 from stu where 1=0 INSERT INTO stu1 SELECT * FROM stu WHERE sex=1

delete from stu1 where number in (select number from stu)

update stu1 set name=\'Jim\' update stu1 set name=\'Jack\' where number=\'000111\'

update grade set grade=grade+1 where number=(select number from stu where name=\'黎明\')