mysql计数器设计_用PHP和MYSQL建立计数器过程详解

以下为引用的内容：

运行MYSQL.EXE

mysql> create database counter;

Query OK, 1 row affected (0.10 sec)

mysql> use counter;

Database changed

mysql> create table tl(id integer(2),count integer(5));

Query OK, 0 rows affected (0.21 sec)

mysql> show columns from tl;

+-------+--------+------+-----+---------+-------+

| Field | Type   | Null | Key | Default | Extra |

+-------+--------+------+-----+---------+-------+

| id    | int(2) | YES  |     | NULL    |       |

| count | int(5) | YES  |     | NULL    |       |

+-------+--------+------+-----+---------+-------+

2 rows in set (0.05 sec)

mysql> select * from tl;

Empty set (0.08 sec)

mysql> insert into tl(id,count) values(1,1);

Query OK, 1 row affected (0.02 sec)

mysql> select * from tl;

+------+-------+

| id   | count |

+------+-------+

|    1 |     1 |

+------+-------+

1 row in set (0.03 sec)