MySQL手动id自增

Question

我有以下查询:

SET @count = 0;
UPDATE `batch_b`
SET `batch_b`.`printid` = @count:=@count+1;
ORDER BY postal_zone, country, airmail,company;

PrintID 是一个整数，默认值为 0。这不是主键。当我运行查询时，我希望给出一次增量值，但它只是返回 NULL。

Answer 1

用括号括住增量值后就可以了。谢谢你!

Set @counter := 0;
UPDATE `batch_b`
SET `batch_b`.`printid` = (@counter:=@counter+1)
ORDER BY postal_zone, country, airmail,company;