课外天地 李树青学习天地数据库系统原理课件 → 关于数据库操纵语句学习的资料


  共有20892人关注过本帖树形打印复制链接

主题:关于数据库操纵语句学习的资料

帅哥哟,离线,有人找我吗?
admin
  1楼 博客 | 信息 | 搜索 | 邮箱 | 主页 | UC


加好友 发短信 管理员
等级:管理员 帖子:1945 积分:26736 威望:0 精华:34 注册:2003/12/30 16:34:32
关于数据库操纵语句学习的资料  发帖心情 Post By:2006/4/10 20:23:44 [显示全部帖子]

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


 回到顶部