Re: rownum-Problem

[Zoltan Budai]

Hello!

This can be written using User Variables:

set @a:=0;
insert into city (id, name) select @a:=@a+1 as rownum, city from person group by city order by city;

http://dev.mysql.com/doc/mysql/en/variables.html

Regards, Zoltan