资源描述：
《wangling文库》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、1)´´½¨ÃûΪ£¨job£©µÄÊý¾Ý¿âcreatedatabasejob;2)ʹÓÃÊý¾Ý¿âusejob;3)´´½¨ÃûΪ£¨users£©µÄÊý¾Ý±ícreatetableusers(useridint(10)primarykeynotnull,usernamevarchar(20)notnull,passwdvarchar(20)notnull,infotext);4)´´½¨ÃûΪinformationµÄÊý¾Ý±íusejob;createtableinformation(idint(1
2、0)primarykeynotnull,namevarchar(20)notnull,sexvarchar(4)notnull,birthdaydatenotnull,addressvarchar(50)notnull,telvarchar(20)notnull,picblob);5)ʹÓÃÃüÁîÔÚusers±íÖÐÔö¼Ó×ֶΣºreg_date(×Ö¶ÎÃèÊö£º×¢²áʱ¼ä)varchar(20)²»Îª¿Õusejob;altertableusersaddreg_datevarchar(20)notn
3、ull;6)ÔÚusers±íÖÐÐÞ¸Äinfo×Ö¶ÎΪmy_info¿ÉÒÔΪ¿Õusejob;altertableuserschangeinfomyinfotextnotnull;7)ÔÚinformation±íÖÐÔö¼Ó×ֶΣºpersnaltext²»Îª¿Õreg_date(×Ö¶ÎÃèÊö£º×¢²áʱ¼ä)varchar(20)²»Îª¿ÕÐÞ¸Ätel×Ö¶ÎΪtelephoneint(20)¿ÉÒÔΪ¿Õusejob;altertableinformationaddpersnaltex
4、tnotnull;altertableinformationaddreg_datevarchar(20)notnull;altertableinformationchangeteltelephoneint(20)notnull;8)ʹÓÃÃüÁî·Ö±ðÔÚusers±íÖÐÌí¼Ó10Ìõ¼Ç¼ÐÅÏ¢,ÈÃÆä°´ÕÕ×¢²áʱ¼ä×ֶεĽµÐòÅÅÁÐinsertintousersvalues(1001,'a','10000','',20080102);insertintousersvalues(1002,
5、'b','10001','',20080202);insertintousersvalues(1003,'c','10003','',20080302);insertintousersvalues(1004,'e','10004','',20080402);insertintousersvalues(1005,'f','10005','',20080502);insertintousersvalues(1006,'g','10006','',20080602);insertintousersvalues(1007,'h','
6、10007','',20080702);insertintousersvalues(1008,'i','10008','',20080802);insertintousersvalues(1009,'j','10009','',20080902);insertintousersvalues(1010,'k','10010','',20081002);select*fromusersorderbyreg_datedesc;9)ʹÓÃÃüÁî·Ö±ðÔÚinformation±íÖÐÌí¼Ó10Ìõ¼Ç¼ÐÅÏ¢,ÈÃÆä°
7、´ÕÕ³öÉúÈÕÆڵĽµÐòÅÅÁÐinsertintoinformationvalues(1001,'a','Å®',19880101,'¹ã¶«',1522256,'','ccxv',20081002);insertintoinformation(1002,'b','Å®',19880102,'ËÄ´¨ÖØÇì',153546,'','dcvf',20081002);insertintoinformation(1003,'c','Å®',19880301,'Õã½',153856,'','dcvf',2008100
8、2);insertintoinformation(1004,'d',Å®',19880201,'ÔÆÄÏ',153556,'','fscvd',20081002);insertintoinformation(1005,'e','Å®',19880401,'Î÷²Ø',15356256,''
