Dear Ranchers,
I have a problem can be solve by one of hese ways:
First:
I have an auto-increment key in my table. so what I have in this column is :
1
2
3
4
5
and after deleting some rows, what we will have is :
3
4
5
But I want it to always start by 1 !
is there any key
word in mysql to apply to a column and then make it being sort from 0 to ... for all the time(even after deleting)?
second question:
how can I retrive the first row in my DB ?(answer is not id=0 because az I said after some rounds my first row id is not 0)
thanks,
Sahar.