Mysql建立用户表并使用存储过程生成并插入100万条随机用户数据(MYSQL版本)

    CREATE TABLE user100w(
      id INT NOT NULL AUTO_INCREMENT,
      first_name VARCHAR(10) NOT NULL,
      last_name VARCHAR(10) NOT NULL,
      sex VARCHAR(5) NOT NULL,
      score INT NOT NULL,
      copy_id INT NOT NULL,
      PRIMARY KEY (`id`)
    );
    
      
      
      
      
      
      
      
      
      
    

    DROP PROCEDURE IF EXISTS add_user;  
    DELIMITER //
    create PROCEDURE add_user(in num INT)
    BEGIN
        DECLARE rowid INT DEFAULT 0;
        DECLARE firstname CHAR(1);
        DECLARE name1 CHAR(1);
        DECLARE name2