0

auto increment in sql

if id column has values (1,2,3,4,5,...10) and i insert value 20 for id ,what is the value of new id that i insert? is it 20 or 11?

8th Aug 2017, 8:57 AM
fateme
2 Antworten
+ 1
20 still but if you dont specify the value it will automate to 11
8th Aug 2017, 8:59 AM
David Sebastian Keshvi Illiakis
David Sebastian Keshvi Illiakis - avatar
0
now if i nsert without specifying it,is the value of it 21 or 11?
9th Aug 2017, 9:42 PM
fateme