mysql generate 1000000 rows with random data

?

CREATE TABLE `data`

(

  `id`         bigint(20) NOT NULL      AUTO_INCREMENT,

  `datetime`   timestamp  NULL          DEFAULT CURRENT_TIMESTAMP,

  `channel`    int(11)                  DEFAULT NULL,

  `value`      float                    DEFAULT NULL,

 

  PRIMARY KEY (`id`)

);

 

 

DELIMITER $$

CREATE PROCEDURE generate_data()

BEGIN

  DECLARE i INT DEFAULT 0;

  WHILE i < 1000 DO

    INSERT INTO `data` (`datetime`,`value`,`channel`) VALUES (

      FROM_UNIXTIME(UNIX_TIMESTAMP('2014-01-01 01:00:00')+FLOOR(RAND()*31536000)),

      ROUND(RAND()*100,2),

      1

    );

    SET i = i + 1;

  END WHILE;

END$$

DELIMITER ;

 

CALL generate_data();

　　

Modify to your needs. To delete the procedure:

DROP PROCEDURE generate_data;