EddyAnn
11/1/2019 - 1:05 AM

navicat批量生成测试数据

CREATE DEFINER=`root`@`localhost` PROCEDURE `proc_initData`( )
BEGIN
	DECLARE
		i INT DEFAULT 1;
	WHILE
			i <= 20000000 DO
			INSERT INTO visit_details (inc_id, area_code, patient_code, created_at, updated_at )
		VALUES
			( i, i, i,  NOW(), NOW());
		
		SET i = i + 1;
		
	END WHILE;

END