SET @outId := 0;
UPDATE test SET id = id + 1, clubId = (select @outId := id) WHERE areaId = 1;
table test
{
id int;
areaId int;
}
SET @outId := 0;
UPDATE test SET id = id + 1, clubId = (select @outId := id) WHERE areaId = 1;
table test
{
id int;
areaId int;
}