修改mysql中Auto_increment值的例子

mysql> show table status from mailbox like 'mailbox';        
+---------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-
--------------------+---------------------+-------------------+----------+----------------+---------+
| Name    | Engine | Version | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free |Auto_increment| Create_time         |
Update_time         | Check_time          | Collation         | Checksum | Create_options | Comment |
+---------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-
--------------------+---------------------+-------------------+----------+----------------+---------+
| mailbox | myisam |      10 | Dynamic    | 1681 |            148 |      249688 | 281474976710655 |       104448 |         0 |         15355| 2012-03-13 11:19:10 |
2012-03-13 11:19:10 | 2012-03-13 11:19:10 | latin1_swedish_ci |     NULL |                |         |
+---------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-
--------------------+---------------------+-------------------+----------+----------------+---------+
1 row in set (0.00 sec)

mysql> alter table mailbox.mailbox auto_increment=20000;         
Query OK, 1681 rows affected (0.05 sec)