資源描述：
《wangling文庫(kù)》由會(huì)員上傳分享，免費(fèi)在線(xiàn)閱讀，更多相關(guān)內(nèi)容在教育資源-天天文庫(kù)。
1、1)′′?¨???a￡¨job￡?μ?êy?Y?acreatedatabasejob;2)ê1ó?êy?Y?ausejob;3)′′?¨???a￡¨users￡?μ?êy?Y±ícreatetableusers(useridint(10)primarykeynotnull,usernamevarchar(20)notnull,passwdvarchar(20)notnull,infotext);4)′′?¨???ainformationμ?êy?Y±íusejob;createtableinformation(idint(1
2、0)primarykeynotnull,namevarchar(20)notnull,sexvarchar(4)notnull,birthdaydatenotnull,addressvarchar(50)notnull,telvarchar(20)notnull,picblob);5)ê1ó??üá??úusers±í?D???ó×???￡oreg_date(×????èê?￡o×￠2áê±??)varchar(20)2??a??usejob;altertableusersaddreg_datevarchar(20)notn
3、ull;6)?úusers±í?DDT??info×????amy_info?éò??a??usejob;altertableuserschangeinfomyinfotextnotnull;7)?úinformation±í?D???ó×???￡opersnaltext2??a??reg_date(×????èê?￡o×￠2áê±??)varchar(20)2??a??DT??tel×????atelephoneint(20)?éò??a??usejob;altertableinformationaddpersnaltex
4、tnotnull;altertableinformationaddreg_datevarchar(20)notnull;altertableinformationchangeteltelephoneint(20)notnull;8)ê1ó??üá?·?±e?úusers±í?Dìí?ó10ì?????D??￠,è???°′??×￠2áê±??×???μ??μDò??áDinsertintousersvalues(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)ê1ó??üá?·?±e?úinformation±í?Dìí?ó10ì?????D??￠,è???°
7、′??3?éúè??úμ??μDò??áDinsertintoinformationvalues(1001,'a','??',19880101,'1???',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,'?÷2?',15356256,''
