22,207
社区成员
发帖
与我相关
我的任务
分享
UPDATE tablename SET 点击数=FLOOR(100 + (RAND() * 101)) WHERE 点击数=0 AND 文章id BETWEEN 1 AND 9000
UPDATE tablename SET 点击数=100+ABS(CHECKSUM(NEWID())%101) WHERE 点击数=0 AND 文章id BETWEEN 1 AND 9000
update 文章 set 点击数 = FLOOR(100 + (RAND() * 200));