DROP PROCEDURE
IF
EXISTS fun1;
DELIMITER $
CREATE PROCEDURE fun1 () BEGIN
DECLARE
i INT DEFAULT 1;
WHILE
i <= 100 DO
INSERT INTO m_user ( `username`, `email`, `password`, `status`, `created` )
VALUES
(
concat( 'name_0502_', CONVERT ( i, CHAR ), 't' ),
concat( 'email_0502_', CONVERT ( i, CHAR ), '@qq.com' ),
'222',
0,
'2022-05-02 00:26:27'
);
SET i = i + 1;
END WHILE;
END $ CALL fun1 ();
mysql 批量插入表 不同数据
最新推荐文章于 2022-10-19 15:02:07 发布