利用sql语句产生随机测试数据
详细代码如下
create database test;
use test;
drop table if exists `card` ;
CREATE TABLE `card` (
`card_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'ID',
`card_number` varchar(100) DEFAULT NULL COMMENT '卡号',
PRIMARY KEY (`card_id`)
) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=utf8 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;
DROP PROCEDURE IF EXISTS proc1;
DELIMITER $$
SET AUTOCOMMIT = 0$$
CREATE PROCEDURE proc1()
BEGIN
DECLARE v_cnt DECIMAL (10) DEFAULT 0 ;
dd:LOOP
INSERT INTO card (card_number) VALUES (UUID());
COMMIT;
num = 10000;
SET v_cnt = v_cnt+1 ;
IF v_cnt = num THEN LEAVE dd;
END IF;
END LOOP dd ;
END;$$
DELIMITER ;
call proc1;
num用来设置产生的数据条数。