Say I have a table like this:
1 JAMES BOND
2 GEORGE BUSH
3 BILL CLINTON
...up to 100 rows.
How would I update the ROWID to ROWID+15?
I guess I need to do it in reverse order, starting with ROWID 100=>115, then ROWID 99=>114, as I get a duplicate key error if I just do a regular:
update `MYTABLE` set `ROWID`=`ROWID`+15
What little bit of MySQL am I missing?