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
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?
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
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.
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
who is telling lie