mysql 随机数

mysql

• 随机获取指定位数的字符串

select substring(MD5(RAND()),1,15);

• 随机获取指定位数的数字,推荐使用第二个

select FLOOR( 0 + RAND() *8) from dual;

SELECT CEILING(RAND()*90000+100000);

将a1中的字段和一个随机数字，插入到target表中

insert into target 
(target.field1, target.field2) 
(
    select a1, (SELECT CEILING(RAND()*90000+100000)) 
    from (select distinct a.a1 from a) as tmp
    );

• 更新

update items inner join item_tmp on items.item = item_tmp.item
set items.item=item_tmp.tmp;