Originally Posted by RefaStud

if you are just updating the appear_id's and nothing else you can do something like this.

UPDATE records set appear_order=appear_order + 1;


that assumes you want to auto_increment the number by 1 in EVERY ROW in the DB;