mysql

create table sub(
id int comment '编号',
email varchar(60) COMMENT '订购的邮箱地址',
status int comment '是否确认，0未确认，1已确认',
code varchar(10) comment '邮箱确认的验证码'
)DEFAULT charset=utf8;

INSERT into sub VALUES(1,'123@126.com',1,'trbxpo'),
(2,'456@126.com',1,'loicpe'),
(3,'789@126.com',0,'jixdami'),
(4,'100@126.com',0,'qwwwrty');

select * from sub where status=1;

update sub set status =1 where id=3;

DELETE from sub where id=2;