mysql auto increment_MySQL的auto_increment的基本特性和使用注意点

4.一个表有且只能有一个auto_increment属性,自增长列必须是索引

5.如果表中的auto_increment最大值被删除，不会被重用。即会跳号

mysql> select * from test;

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

| id | name       |

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

|  1 | zhanghui   |

|  2 | liubei     |

|  3 | guanyu     |

|  5 | shjhsdshjd |

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

4 rows in set (0.00 sec)

mysql> delete from test where id=5;

Query OK, 1 row affected (0.01 sec)

mysql>

mysql> insert into test values(null,'machao');

Query OK, 1 row affected (0.01 sec)

mysql> select * from test;

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

| id | name     |

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

|  1 | zhanghui |

|  2 | liubei   |

|  3 | guanyu   |

|  6 | machao   |

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

4 rows in set (0.00 sec)