MySql添加一个自增的id列 @ROW:=@ROW+1 控制每次按几个递增 (select @ROW := 0) TR 表示从第几位数字+1开始增加 例:SELECT @ROW:=@ROW+1 as id,unitId,IF(num=‘无’,‘暂无’,num) AS num,complaintTime FROM tb_complaint_management_info,(select @ROW := 0) TR 返回示例: