use Weibo

create table Wuser(
Wid int primary key identity(1,1) not null,
Wemail varchar(50) not null UNIQUE,
Pwd varchar(50) not null,
Wname varchar(50) not null unique,
Wintroduction varchar(50),
Wphoto varchar(50) 
)

create table 


insert into Wuser(Wemail,Pwd,Wname,Wintroduction,Wphoto) 
select 'Roy@qq.com','123456','Roy','','1.jpg'



select * from Wuser


drop table Wuser

update Wuser set Wphoto='default.jpg' where wid =3

select Wid from Wuser  where Wemail='Roy@qq.com'