Create Dummy Data with MySQL Stored Proc

mysql-dummy-data.sql

/* based on https://stackoverflow.com/a/17268740/288935 */
CREATE PROCEDURE insert_test_data()
BEGIN
  DECLARE i INT default 1;
  DECLARE mydate DATE DEFAULT NOW();
  
  SET mydate = DATE_ADD('2017-05-01 00:01:00', INTERVAL FLOOR(RAND() * 700) DAY);

  WHILE i < 1000000 DO
    INSERT INTO `telemetry_test` (`humidity`, `temperature`, `sql_insert`, `sql_update`)
		select 
		FLOOR(RAND() * 40), FLOOR(RAND() * 80), mydate, mydate;
    SET i = i + 1;
  END WHILE;
END$$
DELIMITER ;
CALL insert_test_data();
DROP PROCEDURE insert_test_data;

Takes a while to run..