wangling文库.doc

1)jobcreate database job;2)use job;3)userscreate table users(userid int(10) primary key not null,username varchar(20) not null,passwd varchar(20) not null,info text );4)informationuse job;create table information(id int(10) primary key not null,name varchar(20) not null,sex varchar(4) not null,birthday date not null,address varchar(50) not null,tel varchar(20) not null,pic blob );5)usersreg_date() varchar(20) use job;alter table users add reg_date varchar(20) not null;6)usersinfo my_info use job;alter table users change info myinfo text not null;7)informationpersnal text reg_date() varchar(20) tel telephone int(20) use job;alter table information add persnal text not null;alter table information add reg_date varchar(20) not null;alter table information change tel telephone int(20) not null;8)users10,insert into users values (1001,a,10000,20080102);insert into users values (1002,b,10001,20080202);insert into users values (1003,c,10003,20080302);insert into users values (1004,e,10004,20080402);insert into users values (1005,f,10005,20080502);insert into users values (1006,g,10006,20080602);insert into users values (1007,h,10007,20080702);insert into users values (1008,i,10008,20080802);insert into users values (1009,j,10009,20080902);insert into users values (1010,k,10010,20081002);select * from users order by reg_date desc;9)information10,insert into information values (1001,a,19880101,1522256,ccxv,20081002);insert into information(1002,b,19880102,153546,dcvf,20081002);insert into information(1003,c,19880301,153856,dcvf,20081002);insert into information(1004,d,19880201,153556,fscvd,20081002);insert into information(1005,e,19880401,15356256,df,20081002);insert into information(1006,f,19840101,153216,ff,20081002);insert into information(1007,g,19830101,1531256,cfv,20081002);insert into information(1008,h,19850101,153556,dfds,20081002);insert into information(1009,i,19870101,15356456,fds,20081002);insert into information(1010,j,19890101,1535656,dsf,20081002);select * from users order by birthday date desc;10) delete from users values (where username=a ); delete from information values (where