[MySQL] AUTO_INCREMENT 초기화

[ 현재 auto_increment 확인 ]

 

아래 예제는 list 테이블의 auto_increment 값을 확인하는 쿼리이며, Auto_increment 컬럼에서 다음 순번을 확인할 수 있습니다.

 

mysql> show table status like 'list';
+------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+--------------------+----------+----------------+---------+
| 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 |
+------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+--------------------+----------+----------------+---------+
| list | InnoDB |      10 | Dynamic    |    0 |              0 |       16384 |               0 |        32768 |         0 |        3855011 | 2023-01-17 08:29:02 | NULL        | NULL       | utf8mb3_general_ci |     NULL |                |         |
+------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+-------------+------------+--------------------+----------+----------------+---------+

 

 

[ auto_increment 초기화 ]

 

mysql> alter table [테이블명] auto_increment='1';

 

설정 후, 다음 insert 쿼리의 값은 1 번으로 입력됩니다.