如果mysql的表test1有列,一列是id,值为null,一列是其他列,怎么让id自增呢? SET @r := 0; UPDATE test1 SET id = (@r := @r +1); SELECT * FROM test1;