mysql随意插入数据

1.一般我们测试时数据太少了，如果手动输入的话又太麻烦，我们可以使用mysql的随机插入进行操作

2.创建用户表

create table food(foodid int,foodname varchar(25),price varchar(25));

3.创建存储过程

DROP PROCEDURE IF EXISTS add_user;  
DELIMITER //
    create PROCEDURE add_user(in num INT)
    BEGIN
        DECLARE foodid INT DEFAULT 0;
        DECLARE foodname VARCHAR(25);
        DECLARE price VARCHAR(25);
        WHILE foodid < num DO
        SET foodname = SUBSTRING('赵钱孙李周吴郑王林杨柳刘孙陈江阮侯邹高彭徐',FLOOR(1+21*RAND()),1); 
        SET price = SUBSTRING('一二三四五六七八九十甲乙丙丁静景京晶名明铭敏闵民军君俊骏天田甜兲恬益依成城诚立莉力黎励',ROUND(1+43*RAND()),1);  
        #SET sex=FLOOR(0 + (RAND() * 2));
        #SET score= FLOOR(40 + (RAND() *60));
        SET foodid= foodid+ 1;
        insert INTO food (foodid ,foodname ,price) VALUES (foodid ,foodname ,price);  
        END WHILE;
    END //
DELIMITER ;

4.随机插入100条信息

call add_user(100);