存储过程

批量创建终端存储过程

CREATE DEFINER=`root`@`%` PROCEDURE `12`()

BEGIN

         declare i int;SET i =1;

WHILE(i<=100) DO

INSERT INTO w_pick (`pickid`,`gatewayid`,`substationid`,`pickname`,`logicdeviceno`, `terminaltype`,`protocoltype`,`interfacetype`, `baudrate`, `hardport`,`usestate`, `dept_id`,`serialdatabits`,`serialstopbits`,`serialparity`)

  VALUES (CONCAT('b',i), '61000510','b0772e0c0a524e8ca60a6981016d142b',CONCAT('电测表',i),hex(i),'pick_import_DT_HTD830CD','ed567194782d4f42b2cde3fbb8d3b7f9','1','9600','03','1','100','08','00','00');

  SET i = i+1;

END WHILE;

END