//阿里云rds数据库命令 网站地址: https://dms-rds.aliyun.com/
#DELIMITER $ 声明一个分隔符 $
#结束时也要调用多一次 $
##################拼接字符串,CONCAT_WS(分隔符,第一个字符串,第二个字符串)
#例子: CONCAT_WS(i,'http://img2.51zhihuijia.com/user_video/2018/08-29/','.mp4?x-oss-process=video/snapshot,t_1000,m_fast,w_220,h_300')
##################获取当前时间戳,UNIX_TIMESTAMP(NOW())
##################获取 min 到 max 的随机数 FLOOR(min + RAND() * (max - min + 1))
##################获取 1 到 35 的随机数 FLOOR(1 + RAND() * (35 - 1 + 1))
drop procedure if EXISTS pwhile;
DELIMITER $;
create procedure pwhile()
begin
declare i int;
set i = 6123;
while i <= 6135 do
INSERT into user_video(user_id,cdn_video_url,cdn_thumb_img ,city,addtime,click_count,is_show) value ((i-759),CONCAT_WS(i,'http://你cdn的域名/user_video/2018/08-29/','.mp4'),CONCAT_WS(i,'http://你cdn的域名/user_video/2018/08-29/','.mp4?x-oss-process=video/snapshot,t_1000,m_fast,w_220,h_300'),0,UNIX_TIMESTAMP(NOW()),FLOOR(1 + RAND() * (35 - 1 + 1)),1);
set i = i+1;
end while;
end;
$;
call pwhile();