|
稍微给你改了下，，，可以了CREATE PROCEDURE BatchInsert(IN init INT, IN loop_time INT)BEGINDECLARE Var INT;DECLARE ID INT;SET Var = 0;SET ID = init;WHILE Var < loop_time DOinsert into employees(id,fname,lname,birth,hired,separated,job_code,store_id)values(ID,CONCAT('chen',ID),CONCAT('haixiang',ID),Now(),Now(),Now(),1,ID);SE... |
