mysql生成随机数的函数
例:update [tablename] set [columnname] = FLOOR( 6546541 + RAND() * (987987989 - 6546541)) where ?
FLOOR( 6546541 + RAND() * (987987989 - 6546541)) ==> 输出大于6546541且小于987987989的随机整数
例:update [tablename] set [columnname] = FLOOR( 6546541 + RAND() * (987987989 - 6546541)) where ?
FLOOR( 6546541 + RAND() * (987987989 - 6546541)) ==> 输出大于6546541且小于987987989的随机整数