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;