IF EXISTS (select * from dbo.sysobjects where Name = 'stuMarks')
drop table stuMarks
create table stuMarks
(
id int identity(1,1) primary key,
name char(20) not null,
sex char(20) not null,
phone char(20) not null,
address char(40) not null,
email char(20) not null,
)
go
insert into stuMarks values('zhangzhen','men','15172537121','wuhandaxue','2507797739')
insert into stuMarks values('zhangsan','men','12172537456','wuhandaxue','2507797738@qq.com')
insert into stuMarks values('liuxioahan','female','187172537456','wuhandaxue','2907797738@qq.com')
select * from stuMarks;
DELETE FROM stuMarks WHERE id=2;
update stuMarks set email='2507797739@qq.com' where id='1';
select * from stuMarks where id=1;