update document_info set download_count=download_count+(SELECT 20+FLOOR(500 + (RAND() * 2000))) where download_count = 0
若要在7 到 12 的范围(包括7和12)内得到一个随机整数, 可使用以下语句:
SELECT FLOOR(7 + (RAND() * 6));
update document_info set download_count=download_count+(SELECT 20+FLOOR(500 + (RAND() * 2000))) where download_count = 0
若要在7 到 12 的范围(包括7和12)内得到一个随机整数, 可使用以下语句:
SELECT FLOOR(7 + (RAND() * 6));