使用mysql存储过程添加数据

DELIMITER //
create PROCEDURE insert_logs_test(in loop_times INT)
BEGIN
	DECLARE var INT DEFAULT 0; 
	DECLARE l_datetime datetime DEFAULT '2016-03-31 16:00:00';
	WHILE var < loop_times DO
	insert INTO his_log (cid,uid,mac,inpuId,listId,templeteId,originPath,browseTime,browseNum,ip,province,city) VALUES (1,1001,'00-01-02-10-23',1000233,189,1,0,l_datetime,var,'12.56.36.123','广东省','深圳市');
	SET var = var + 1;
	SET l_datetime = DATE_ADD(l_datetime,INTERVAL 1 HOUR);
	END WHILE; 
END
//
DELIMITER ;

call insert_logs_test_4(25)


//
若要在i ≤ R ≤ j 这个范围得到一个随机整数R 
FLOOR(i + RAND() * (j – i + 1))
FLOOR(0 + RAND() * (24 – 0 + 1))

　　

转载于:https://www.cnblogs.com/lazyboy1/p/5405411.html