How do one auto increment for an employee ID that doesnot start from 1 example 1001 | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

How do one auto increment for an employee ID that doesnot start from 1 example 1001

16th May 2020, 2:02 AM
AKINTOBI ABIBAT OLAMIDE
4 Answers
0
No Issues with it.. Just put the AUTOINCREMENT query and define starting value as '1001' it will start to count the next number
16th May 2020, 9:52 AM
Tejas Amit Sheth
0
(1001, 5) Can we add 5 to tell it to increment the number by 5.
16th May 2020, 10:02 AM
AKINTOBI ABIBAT OLAMIDE
16th May 2020, 10:06 AM
Tejas Amit Sheth
0
Thanks
16th May 2020, 10:06 AM
AKINTOBI ABIBAT OLAMIDE