Linux Ask!

Linux Ask! is a Q & A web site specific for Linux related questions. Questions are collected, answered and audited by experienced Linux users.

Set the auto increment start value in MySQL?

Answer:

In MySQL, you can change the table's auto increment start value by the following command.

mysql> ALTER TABLE `my_table` AUTO_INCREMENT = 2000;

Query OK, 2 rows affected (0.06 sec)
Records: 2  Duplicates: 0  Warnings: 0
  1. How to create a transaction in MySQL
  2. Reset MySQL root password
  3. Create temporary table in MySQL
  4. How to show the warnings during mysqlimport
  5. How to rename table in MySQL

Leave a Reply

(required)

(required)

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>