--初始化20~80随机整数
UPDATE topic_video set
`zan_count` = FLOOR(20 + (RAND() * 60)),
`share_count` = FLOOR(20 + (RAND() * 60)),
`collect_count` = FLOOR(20 + (RAND() * 60));
mysql的FIND_IN_SET函数
--初始化20~80随机整数
UPDATE topic_video set
`zan_count` = FLOOR(20 + (RAND() * 60)),
`share_count` = FLOOR(20 + (RAND() * 60)),
`collect_count` = FLOOR(20 + (RAND() * 60));
mysql的FIND_IN_SET函数