MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE USER_TB (ID INT Auto_inCREMENT Primary KEY,
NICKNAME varchar(50)
,USER_LV INT ,
EXP BIGINT)
INSERT INTO USER_TB (ID,NICKNAME,USER_LV,EXP) VALUES (2,'test1',1,0),(NULL,'test2',1,0),(NULL,'test3',1,0),(NULL,'test4',1,0),
(NULL,'test5',1,0),(NULL,'test6',1,0),(NULL,'test7',1,0),(NULL,'test8',1,0),
(NULL,'test9',1,0),(NULL,'test10',1,0),(NULL,'test11',1,0),(NULL,'test12',1,0);
SELECT LAST_INSERT_ID(); 


LAST_INSERT_ID()


3


INSERT INTO USER_TB VALUES (NULL,'test13',1,0),(NULL,'test14',1,0)
SELECT LAST_INSERT_ID(); 


LAST_INSERT_ID()


15


SELECT * FROM USER_TB;


ID
NICKNAME
USER_LV
EXP


2
test1
1
0

3
test2
1
0

4
test3
1
0

5
test4
1
0

6
test5
1
0

7
test6
1
0

8
test7
1
0

9
test8
1
0

10
test9
1
0

11
test10
1
0

12
test11
1
0

13
test12
1
0

15
test13
1
0

16
test14
1
0

ID	NICKNAME	USER_LV
2	test1	1
3	test2	1
4	test3	1
5	test4	1
6	test5	1
7	test6	1
8	test7	1
9	test8	1
10	test9	1
11	test10	1
12	test11	1
13	test12	1
15	test13	1
16	test14	1