mysql 变量

SELECT
(
@i := 
case WHEN car_lg =@pre_code THEN
@i + 1
ELSE
1
END
) as aaa ,car_no
FROM
(
SELECT
car_no,car_lg,(@pre_code := car_lg)
FROM
device_car a,
(SELECT @i := 0, @pre_code := '') b

) c where car_no is not null;

(SELECT @i := 0, @pre_code := '') b 声明局部变量

(@pre_code := car_lg)定义变量值

(
@i := 
case WHEN car_lg =@pre_code THEN
@i + 1
ELSE
1
END

)定义变量值

简单理解