Generate a sequence of integers in MySQL?

To create a sequence of integers in MySQL, you can use AUTO_INCREMENT. Remember, there are no special commands to create sequences of integers. AUTO_INCREMENT will help create a sequence of integers in MySQL.

AUTO_INCREMENT starts from 1 by default. You can change it to another number using the alter command. Let's look at an example. Let's say your initial value is 1000. Then the next number will be 1000 1 = 1001.

This is an example of AUTO_INCREMENT. The query to create the table is as follows:

mysql> create table AutoIncrementDemo
   −> (
      −> EmployeeId int AUTO_INCREMENT,
      −> primary key(EmployeeId)
   −> );
Query OK, 0 rows affected (0.54 sec)

Insert records that generate an integer sequence. The query is as follows −

mysql> insert into AutoIncrementDemo values();
Query OK, 1 row affected (0.13 sec)

mysql> insert into AutoIncrementDemo values();
Query OK, 1 row affected (0.27 sec)

mysql> insert into AutoIncrementDemo values();
Query OK, 1 row affected (0.09 sec)

mysql> insert into AutoIncrementDemo values();
Query OK, 1 row affected (0.09 sec)

mysql> insert into AutoIncrementDemo values();
Query OK, 1 row affected (0.09 sec)

mysql> insert into AutoIncrementDemo values();
Query OK, 1 row affected (0.07 sec)

You can use the select statement to check the integer sequence. The query is as follows −

mysql> select *from AutoIncrementDemo;

The following is the output −

+------------+
| EmployeeId |
+------------+
|          1 |
|          2 |
|          3 |
|          4 |
|          5 |
|          6 |
+------------+
6 rows in set (0.00 sec)

The above is the detailed content of Generate a sequence of integers in MySQL?. For more information, please follow other related articles on the PHP Chinese website!