ʵÑéÈý ¶ÔÏóµÄ½¨Á¢ÓëÊý¾Ý¸üвÙ×÷
Ò» ʵÑéÒªÇó
1 ´´½¨ºÍÐ޸ĶÔÏó £¨1£©´´½¨±í¶ÔÏó
°´ÕÕÏÂÃæµÄµÄ½á¹¹ÓëÄÚÈݽ¨Á½¸ö¹Øϵ¡£±íÃû·Ö±ðÒÔS¡¢T ¿ªÍ·£¬ºóÃæÊǽ¨±íÈ˵ÄѧºÅ(ÒÔϼò¼ÇΪT**¡¢S** )¡£ÏÈÓÃcreate table ÃüÁÁ¢±íµÄ³õʼ½á¹¹£¬±íT**µÄ³õʼ½á¹¹°üÀ¨ÏÂÃæT**ÖÐÇ°ËĸöÊôÐÔ¡£È»ºóÔÙÓÃalter table .add. Ìí¼ÓÒ»¸öÊôÐÔ: QTY(¿â´æÁ¿)¡£²¢²åÈëÏàÓ¦µÄÄÚÈÝ¡£
T** Title ¼ÆËã»úÔÀí CÓïÑÔ³ÌÐòÉè¼Æ Êý¾Ý¿âÔÀí ¼ÆËã»úÍøÂç Artificial intelligence Expert systems Èí¼þ¹¤³Ì Fortran ³ÌÐòÉè¼Æ R.Ullman Â³Í¢è° ¹Ëѧ·å H3067 S2005 S5006 17.00 35.00 18.00 370 200 180 author ÕÅһƽ À Íõ¼ÒÊ÷ ¸ßÃ÷ P.Winston t_no S3092 price QTY 20.80 200 150 400 H1298 15.30 300 D1007 22.70 S5690 18.90 230 D2008 20.50 S**
T_no S3092 D1007 S5006 S5690
Page 304 280 315 300 17
pub-date 1986 1993 1987 1993
H1298 D2008 S2005 H3067 210 358 298 307 1989 1994 1995 1995 £¨2£©ÓÃalter table.alter column.¸Ä±äÊôÐÔtitle µÄ³¤¶È¡£
£¨3£©ÓÃ×Ó²éѯ·½Ê½½¨ÐÂ±í¡£±íÃûÒÔST ¿ªÍ·, ºóÃæΪ½¨±íÈËѧºÅ(¼ò¼ÇΪST** )¡£ (бíÄÚÐë°üÀ¨titleºÍprice Á½¸öÊôÐÔ¡£)
£¨4£©°´t_no ½¨Ë÷Òý£¬Ë÷ÒýÃûΪIT** £¨**±íʾ½¨±íÈ˵ÄѧºÅ£¬ÏÂͬ£©¡£ £¨5£©ÓÃ×Ó²éѯ·½Ê½½¨ÊÓͼ£¬ÊÓͼÃûΪVT** , ²¢ÔÚÊÓͼÉϲéÕÒËùÐèÐÅÏ¢¡£ £¨6£©É¾³ýÒÔVT** ÃüÃûµÄÊÓͼ¡£ £¨7£©É¾³ýÒÔST** ÃüÃûµÄ±í¡£ 2¡¢¼Ç¼µÄ²åÈ롢ɾ³ýÓë¸üÐÂ
£¨1£©Í¬Ç°£¬ÓÃ×Ó²éѯ·½Ê½½¨Á¢±íST** ¡£¸Ã±íµÄÊôÐÔÓ¦ÓÐt_no, title, price¡£ £¨2£©ÔÚST** ±íÖвåÈëÒ»Ôª×é: S7028, Digital Image Processing, 36.00 £¨3£©É¾³ýÊéÃûΪ¡°Fortran ³ÌÐòÉè¼Æ¡±µÄÄǸöÔª×é¡£ £¨4£©É¾³ýÊéºÅÒÔH ¿ªÍ·µÄÔª×é¡£ £¨5£©°ÑÊé¼Ûµ÷Õûµ½ÔÀ´¼Û¸ñµÄ95% ¡£
£¨6£©°ÑÊéºÅÒÔD ¿ªÍ·µÄÄÇЩÊéµÄÊé¼Û¼õµô2.00Ôª¡£ £¨7£©½«¡°¼ÆËã»úÔÀí¡±µÄÊéºÅ¸ÄΪS1135¡£
£¨8£©¶ÔËù½¨µÄ±í£¬½øÐи÷ÖÖ²åÈ롢ɾ³ý¡¢¸üвÙ×÷¡£
£¨9£©Ã¿´ÎÐ޸ıíºó£¬¿ÉÓÃselect ²é¿´Ò»ÏÂÐ޸ĺó±íÖеÄÄÚÈÝ£¬¿´ÊÇ·ñÂú×ãÒªÇó¡£ 3¡¢Í³¼Æ
£¨1£©¼ÆËãT** ±íÖÐÕâЩÊé¼®µÄ×î¸ßÊé¼Û¡¢×îµÍÊé¼Û¼°Æ½¾ùÊé¼Û¡£ £¨2£©¼ÆËãT** ±íÖеÄÊéµÄÖÖÀàÊǶàÉÙ¡£ £¨3£©¼ÆËãS** ±íÖÐ1990Äêºó³ö°æµÄÊéÓжàÉÙ¡£ £¨4£©¼ÆËã×ܹ²ÓжàÉÙ±¾Êé¡£
£¨5£©¶ÔÑùÀý±í£¬Éè¼Æͳ¼ÆÒªÇ󣬻ñµÃ¸÷ÖÖͳ¼ÆÁ¿¡£
18
¶þ ʵÑé½á¹û
/* 1 */ /*(1)*/
create database student use student
create table T631507020418( Title varchar(30), author varchar(15), t_no char(6),
price numeric(6,2) )
insert into T631507020418(Title,author,t_no,price) select '¼ÆËã»úÔÀí','ÕÅһƽ','S3092','20.8' union all
select 'CÓïÑÔ³ÌÐòÉè¼Æ','À','H1298','15.3' union all
select 'Êý¾Ý¿âÔÀí','Íõ¼ÒÊ÷','D1007','22.7' union all
select '¼ÆËã»úÍøÂç','¸ßÃ÷','S5690','18.9' union all
select 'Artificial intelligence','P.Winston','D2008','20.5' union all
select 'Expert systems','R.Ullman','H3067','17' union all
select 'Èí¼þ¹¤³Ì','³͢è°','S2005','35' union all
select 'Fortran³ÌÐòÉè¼Æ','¹Ëѧ·å','S5006','18'
alter table T631507020418 add QTY int
update T631507020418 set QTY=200 where t_no='S3092' update T631507020418 set QTY=300 where t_no='H1298' update T631507020418 set QTY=150 where t_no='D1007' update T631507020418 set QTY=230 where t_no='S5690' update T631507020418 set QTY=400 where t_no='D2008' update T631507020418 set QTY=370 where t_no='H3067' update T631507020418 set QTY=200 where t_no='S2005' update T631507020418 set QTY=180 where t_no='S5006'
create table S631507020418(
19
T_no char(6), page int, pub_date date)
insert into S631507020418 select 'S3092','304','1986' union all
select 'D1007','280','1993' union all
select 'S5006','315','1987' union all
select 'S5690','300','1993' union all
select 'H1298','210','1989' union all
select 'D2008','358','1994' union all
select 'S2005','298','1995' union all
select 'H3067','307','1995'
/*(2)*/
alter table T631507020418
alter column Title varchar(35)
/*(3)*/
select Title,price into ST631507020418 from T631507020418
/*(4)*/
create index IT6315070200418 on T631507020418(t_no)
/*(5)*/
create view VT631507020418 as select * from T631507020418
/*(6)*/
drop view VT631507020418
/*(7)*/
drop table ST631507020418
20