[ale] Renumber keys in mysql

[Chris Fowler]

On Thu, 2011-07-21 at 11:58 -0400, Omar Chanouha wrote:
> insert into original (name) select concat(name,'x') from (select *
> from original where id > 50 and id < 150); 

Yep.  He will use concat to rename but some other tables need to be
totally changed.  Some data has to be replaced using update.  Of course
that could be done after the initial insert.  Just do an update ont hose
ids