在mysql中,有没有其他方法可以随机生成带顺序的序列号????
我有一张桌子:验证码
SET @a:= 1;
SELECT @a:=@a+1 as sequence_no,captcha_id, captcha_name
FROM captcha,(SELECT @a:= 0) AS a
ORDER BY RAND()
我的预期产出:
sequence_no | captcha_id | captcha_name
----------------------------------------
01 | 11 | name1
02 | 06 | name2
我的查询输出:
sequence_no | captcha_id | captcha_name
----------------------------------------
11 | 11 | name1
06 | 06 | name2