what is to be done if I want to start the numbering from 100 | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

what is to be done if I want to start the numbering from 100

primary key

18th Sep 2016, 12:45 PM
KSHITIJ BIYANI
KSHITIJ BIYANI - avatar
4 Answers
0
table
18th Sep 2016, 6:36 PM
Michael Ofosu
Michael Ofosu - avatar
0
mayby "LIMIT 100, %"?
19th Sep 2016, 9:27 PM
Владимир Смук
Владимир Смук - avatar
0
Ok
20th Sep 2016, 7:30 PM
Roman Asanov
Roman Asanov - avatar
0
I think you define the column as identity (100,n) where n is increment value after every record you enter. For example if you did identity(100,1), the first record would be 100 and the second one 101.
23rd Sep 2016, 1:48 PM
Philimon Wanja
Philimon Wanja - avatar