what is the sql for this

[comesee]

i have tablename sales

id      name
1       fred
2       john
45     love
3       silver
21      tom


i want the id to look this way

id      name
1       fred
2       john
3       love
4       silver
5       tom 

what is the sql to fix this

[Chen Zhen]

Is it really necessary to change the values in the id column or do you just want to sort the data in ascending order by name for display?

[Kindred]

The biggest question is, WHY do you want to change this?

If you are looking to change the OD in the members table,  then the answer is DO NOT. Changing the I'd in the members table will screw up everything

[Chen Zhen]

The name of the table is "sales".
I think this is just something custom that comesee is trying to sort for display.
Imo a simple order by name ascending clause will likely be what is sought.

[Kindred]

1, comesee is known for lying
2, comesee still does not have an smf copyright
3, comesee posted in smf support, not scripting help

In short.
Nice try, comesee, but no

[comesee]

who is telling lie

[Illori]

who is telling lie

you are.