mysql一括挿入データ

1、テーブルの作成

CREATE TABLE `user` (
  `id` int(50) NOT NULL,
  `username` varchar(255) DEFAULT NULL,
  `sex` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `sign` varchar(255) DEFAULT NULL,
  `experience` int(55) DEFAULT NULL,
  `logins` int(55) DEFAULT NULL,
  `wealth` int(55) DEFAULT NULL,
  `classify` varchar(255) DEFAULT NULL,
  `score` int(55) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

2、一括挿入データ

DROP PROCEDURE
IF
	EXISTS test_insert;

DELIMITER;;
CREATE PROCEDURE test_insert ( ) BEGIN
DECLARE
		i INT DEFAULT 1;
# can not be 0
	WHILE
			i < 1000 DO
		INSERT INTO USER
		VALUES
			(
				i,
				CONCAT( "user", "-", i ),
				" ",
				CONCAT( '  -', i ),
				CONCAT( '  -', i ),
				FLOOR( RAND( ) * 1000 ),
				FLOOR( RAND( ) * 1000 ),
				FLOOR( RAND( ) * 10000 ),
				CONCAT( '  -', i ),
				FLOOR( RAND( ) * 1000 ) 
			);
		
		SET i = i + 1;
		
	END WHILE;
	COMMIT;
	
	END;;
CALL test_insert ( );

注意:https://blog.csdn.net/qq361301276/article/details/7999537