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 (NULL,'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()


1


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


LAST_INSERT_ID()


13


SELECT * FROM USER_TB;


ID
NICKNAME
USER_LV
EXP


1
test1
1
0

2
test2
1
0

3
test3
1
0

4
test4
1
0

5
test5
1
0

6
test6
1
0

7
test7
1
0

8
test8
1
0

9
test9
1
0

10
test10
1
0

11
test11
1
0

12
test12
1
0

13
test13
1
0

14
test14
1
0

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