mysql存储过程，批量插入10000条数据

CREATE PROCEDURE `INSERT_TEST_TERMINAL`(terminalCount int)BEGIN#Routine body goes here...DECLARE i INT DEFAULT 0;DECLARE ISONLINE INT DEFAULT 0;WHILE  i < terminalCountDO IF  i < 5000THEN SET ISONLINE=0;ELSE SET ISONLINE=1;END IF;IF i < 10THENINSERT INTO tmstterminal (TERMINAL_SN, NICK_NAME, CPU, DDR, FLASH, MAC, NETWORK_TYPE, ASSIGNED, PASSWORD, ORGANIZATION_ID, TERMINAL_TYPE, CREATOR, CREATE_DATE, MODIFIER, MODIFY_DATE, ISDELETED)VALUES (CONCAT("test000",i), NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 1, 1, 'admin', SYSDATE(), 'admin', SYSDATE(), 'N');INSERT INTO tmstterminal_state (TERMINAL_SN, ONLINE, SERIAL_KEY_INJECT, SRED, MSR_TRK1_READ_TOTAL, MSR_TRK1_READ_ERROR, MSR_TRK2_READ_TOTAL, MSR_TRK2_READ_ERROR, MSR_TRK3_READ_TOTAL, MSR_TRK3_READ_ERROR, FLASH_USAGE, DDR_USAGE, SENSITIVE_FUNCTION_ACCESS, PIN_ENCRYPTION, TAMPERED, PRIVACY_SHIELD, STYLUS, TERMINAL_STATE_TIME, UPDATE_TIME, IS_VALID)VALUES (CONCAT("test000",i), ISONLINE, NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 1, SYSDATE(), SYSDATE(), 1);ELSE IF i < 100THENINSERT INTO tmstterminal (TERMINAL_SN, NICK_NAME, CPU, DDR, FLASH, MAC, NETWORK_TYPE, ASSIGNED, PASSWORD, ORGANIZATION_ID, TERMINAL_TYPE, CREATOR, CREATE_DATE, MODIFIER, MODIFY_DATE, ISDELETED)VALUES (CONCAT("test00",i), NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 1, 1, 'admin', SYSDATE(), 'admin', SYSDATE(), 'N');INSERT INTO tmstterminal_state (TERMINAL_SN, ONLINE, SERIAL_KEY_INJECT, SRED, MSR_TRK1_READ_TOTAL, MSR_TRK1_READ_ERROR, MSR_TRK2_READ_TOTAL, MSR_TRK2_READ_ERROR, MSR_TRK3_READ_TOTAL, MSR_TRK3_READ_ERROR, FLASH_USAGE, DDR_USAGE, SENSITIVE_FUNCTION_ACCESS, PIN_ENCRYPTION, TAMPERED, PRIVACY_SHIELD, STYLUS, TERMINAL_STATE_TIME, UPDATE_TIME, IS_VALID)VALUES (CONCAT("test00",i), ISONLINE, NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 1, SYSDATE(), SYSDATE(), 1);ELSE IFi < 1000THENINSERT INTO tmstterminal (TERMINAL_SN, NICK_NAME, CPU, DDR, FLASH, MAC, NETWORK_TYPE, ASSIGNED, PASSWORD, ORGANIZATION_ID, TERMINAL_TYPE, CREATOR, CREATE_DATE, MODIFIER, MODIFY_DATE, ISDELETED)VALUES (CONCAT("test0",i), NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 1, 1, 'admin', SYSDATE(), 'admin', SYSDATE(), 'N');INSERT INTO tmstterminal_state (TERMINAL_SN, ONLINE, SERIAL_KEY_INJECT, SRED, MSR_TRK1_READ_TOTAL, MSR_TRK1_READ_ERROR, MSR_TRK2_READ_TOTAL, MSR_TRK2_READ_ERROR, MSR_TRK3_READ_TOTAL, MSR_TRK3_READ_ERROR, FLASH_USAGE, DDR_USAGE, SENSITIVE_FUNCTION_ACCESS, PIN_ENCRYPTION, TAMPERED, PRIVACY_SHIELD, STYLUS, TERMINAL_STATE_TIME, UPDATE_TIME, IS_VALID)VALUES (CONCAT("test0",i), ISONLINE, NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 1, SYSDATE(), SYSDATE(), 1);ELSEINSERT INTO tmstterminal (TERMINAL_SN, NICK_NAME, CPU, DDR, FLASH, MAC, NETWORK_TYPE, ASSIGNED, PASSWORD, ORGANIZATION_ID, TERMINAL_TYPE, CREATOR, CREATE_DATE, MODIFIER, MODIFY_DATE, ISDELETED)VALUES (CONCAT("test",i), NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 1, 1, 'admin', SYSDATE(), 'admin', SYSDATE(), 'N');INSERT INTO tmstterminal_state (TERMINAL_SN, ONLINE, SERIAL_KEY_INJECT, SRED, MSR_TRK1_READ_TOTAL, MSR_TRK1_READ_ERROR, MSR_TRK2_READ_TOTAL, MSR_TRK2_READ_ERROR, MSR_TRK3_READ_TOTAL, MSR_TRK3_READ_ERROR, FLASH_USAGE, DDR_USAGE, SENSITIVE_FUNCTION_ACCESS, PIN_ENCRYPTION, TAMPERED, PRIVACY_SHIELD, STYLUS, TERMINAL_STATE_TIME, UPDATE_TIME, IS_VALID)VALUES (CONCAT("test",i), ISONLINE, NULL, NULL, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 1, SYSDATE(), SYSDATE(), 1);END IF;END IF;END IF;SET i = i+1;IF  i % 2000 = 0THENCOMMIT;END IF;END WHILE;END;CALL INSERT_TEST_TERMINAL(10000);DROP PROCEDURE INSERT_TEST_TERMINAL;