MySQL—电子杂志订阅表的实现

mysql>CREATE DATABASE mydb;
mysql>USE mydb;

mysql> CREATE TABLE subscribe(id INT COMMENT'编号',email VARCHAR(60) COMMENT'邮箱订阅的邮箱地址',status INT COMMENT'是否确认，0未确认，1确认',code VARCHAR(10) COMMENT'邮箱确认的验证码')DEFAULT CHARSET=utf8;
Query OK, 0 rows affected (0.17 sec)

mysql>INSERT INTO subscribe VALUES
(1,'tom123@163.com','1','TRBXPO'),
(2,'lucy123@163.com','1','LOICPE'),
(3,'lily123@163.com','0','JIXDAMI'),
(4,'jimmy123@163.com','0','QKOLPH'),
(5,'joy123@163.com','1','JSMWNL);

mysql> SELECT * FROM subscribe WHERE status=1;

mysql> UPDATE subscribe SET status=1 WHERE id=4;

mysql> DELETE FROM subscribe WHERE id=5;