simple sql question

[contra10]

I just want to know that if i have an auto incremented table and the auto incremented numbers are lets say 1,2,3,4 to represent each row.

 

If i delete row 2, whats left in my database is 1,3,4. The next input would be 5. 1,3,4,5.

 

Question: Is there a way to allow the next created row to be 2 instead of being 5?

 

I guess I'm just trying to reorganize

[MasterACE14]

I'm not sure, but you might be able to use PHP to find the first missing number, and then set that as the value to insert in the auto increment column.

[contra10]

so should my script be something like "ALTER table"...although i wouldn't know what top put...

 

is there a way in php my admin

[revraz]

Auto Increment is just that, you can't force a number into the field.  And why would you want to?

[contra10]

i'm afraid that eventually my number is going to be too high, plus i really am not a fan of long urls...

 

but i was looking around and there's suppose to be an alter code...this is what im doing but doesn't really work

 

ye i guess ill just deal with it

[nankoweap]

if you want that kind of control over an ID column, i'd suggest not using auto increment and write the code to do it yourself. of course, i'm not sure why one would want to do this. i mean, what value-add to the application and its users would justify this? i make my ID columns unsigned bigints and don't worry about it.

 

jason

[revraz]

The Alter command sets the Autoincrement value to something different, not allows you to put a number in the field.