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='黎明')