MYSQL存储引擎例子

delete from employees
CREATE TABLE employees (
   id INT NOT NULL,
   fname VARCHAR(30),
   lname VARCHAR(30),
   birth TIMESTAMP,
   hired DATE NOT NULL DEFAULT '1970-01-01',
   separated DATE NOT NULL DEFAULT '9999-12-31',
   job_code INT NOT NULL,
   store_id INT NOT NULL
   )
   partition BY RANGE (store_id) (
   partition p0 VALUES LESS THAN (10000),
   partition p1 VALUES LESS THAN (50000),
   partition p2 VALUES LESS THAN (100000),
   partition p3 VALUES LESS THAN (150000),
   Partition p4 VALUES LESS THAN MAXVALUE
   );
    
use mysql_test;    
DROP PROCEDURE IF EXISTS BatchInsert;
delimiter //   -- 把界定符改成双斜杠
CREATE PROCEDURE BatchInsert(IN init INT, IN loop_time INT)  -- 第一个参数为初始ID号（可自定义），第二个位生成MySQL记录个数
  BEGIN
      DECLARE Var INT;
      DECLARE ID INT;
      SET Var = 0;
      SET ID = init;
      WHILE Var < loop_time DO
          insert into employees(id, fname, lname, birth, hired, separated, job_code, store_id) values (ID, CONCAT('SN00000000', ID), CONCAT('HYRB000000', ID), Now(), Now(), Now(), 1, ID);
          SET ID = ID + 1;
          SET Var = Var + 1;
      END WHILE;
  END;
  //
delimiter ; 

CALL BatchInsert(1, 200000);