[ale] Renumber keys in mysql

[Chris Fowler]

On Thu, 2011-07-21 at 11:48 -0400, Omar Chanouha wrote:
> If that works, then why create temp at all? Just nest the select in the line:
> 
> insert into original (name,...) select name,... from (select * from
> original where id > 50 and id < 150);
> 
> http://dev.mysql.com/doc/refman/5.5/en/insert-select.html
> 
> That page may help. I think comment one is along the lines of your situation.

Name is unique and mysql will not allow duplicate names.