mysql主键自增

mysql> create table dd(  
    -> id int primary key not null auto_increment,  
    -> name varchar(20),  
    -> time timestamp default current_timestamp  
    -> );  
Query OK, 0 rows affected (0.10 sec)  
  
mysql> insert into dd(name) values ('fhihgifds');  
Query OK, 1 row affected (0.14 sec)  
  
mysql> insert into dd(name) values ('steven');  
Query OK, 1 row affected (0.08 sec)  
  
mysql> select * from dd;  
+----+-----------+---------------------+  
| id | name      | time                |  
+----+-----------+---------------------+  
|  1 | fhihgifds | 2011-03-27 01:58:46 |  
|  2 | steven    | 2011-03-27 01:59:35 |  
+----+-----------+---------------------+  
2 rows in set (0.08 sec)  
  
mysql> insert into dd(name) values ('anthony');  
Query OK, 1 row affected (0.09 sec)  
  
mysql> select * from dd;  
+----+-----------+---------------------+  
| id | name      | time                |  
+----+-----------+---------------------+  
|  1 | fhihgifds | 2011-03-27 01:58:46 |  
|  2 | steven    | 2011-03-27 01:59:35 |  
|  3 | anthony   | 2011-03-27 02:00:07 |  
+----+-----------+---------------------+  
3 rows in set (0.00 sec)