博客

往students表中插入100条数据

DROP PROCEDURE
IF EXISTS test_data;

DELIMITER $$
CREATE PROCEDURE test_data() 
BEGIN
    -- 定义变量
    DECLARE i INT UNSIGNED DEFAULT 1;  -- 1是变量可以写10000
    -- 循环次数
    WHILE i <= 100 DO										-- i是变量可以 <10000

insert into tom1.students (id,name,hometown,score,zxc,zxcv,zxcv1,zxcv2,zxcv3) VALUES (i,'zhangsan','shenzhen','100','0','0','0','0','0');

        SELECT i;
        SET i = i+1;
    END WHILE;
END $$
--

CALL test_data();