MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT VERSION();

VERSION()

8.0.23

DROP TABLE IF EXISTS `your_table_name`;

CREATE TABLE IF NOT EXISTS `your_table_name` (
  `your_auto_increment_column_name` BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT
);

SHOW CREATE TABLE `your_table_name`;

INSERT INTO `your_table_name` (`your_auto_increment_column_name`)
VALUES (NULL), (NULL), (NULL), (NULL), (NULL);

SELECT `your_auto_increment_column_name`
FROM `your_table_name`;

Table
Create Table

your_table_name
CREATE TABLE `your_table_name` (
  `your_auto_increment_column_name` bigint NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`your_auto_increment_column_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci

your_auto_increment_column_name

1

2

3

4

5

DROP TABLE IF EXISTS `your_table_name`;

CREATE TABLE IF NOT EXISTS `your_table_name` (
  `your_auto_increment_column_name` BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT
);

ALTER TABLE `your_table_name` AUTO_INCREMENT = 1001;

SHOW CREATE TABLE `your_table_name`;

INSERT INTO `your_table_name` (`your_auto_increment_column_name`)
VALUES (NULL), (NULL), (NULL), (NULL), (NULL);

SELECT `your_auto_increment_column_name`
FROM `your_table_name`;

Table
Create Table

your_table_name
CREATE TABLE `your_table_name` (
  `your_auto_increment_column_name` bigint NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`your_auto_increment_column_name`)
) ENGINE=InnoDB AUTO_INCREMENT=1001 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci

your_auto_increment_column_name

1001

1002

1003

1004

1005