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,‘‘,1,‘trbxpo‘),
(2,‘‘,1,‘loicpe‘),
(3,‘‘,0,‘jixdami‘),
(4,‘‘,0,‘qwwwrty‘);

select * from sub where status=1;

update sub set status =1 where id=3;

DELETE from sub where id=2;