#请在此编写SQL语句创建表并插入数据
CREATE TABLE IF NOT EXISTS student
(
student_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
score_math INT NOT NULL,
score_eng INT NOT NULL,
score_art INT NOT NULL
) ENGINE = INNODB DEFAULT CHARSET = utf8;
DROP PROCEDURE IF EXISTS mytest;
DELIMITER $$
CREATE PROCEDURE mytest()
BEGIN
DECLARE n INT DEFAULT 1;
SET @exesql = 'insert into student (score_math,score_eng,score_art) values (88,77,90)';
SET @exedata = '';
WHILE n < 10000 DO
SET @exedata = CONCAT(@exedata,',','(70,86,98)');
SET @exesql=CONCAT(@exesql,@exedata);
SET @exedata = '';
SET n = n + 1;
END WHILE;
SET @exesql=CONCAT(@exesql,";");
PREPARE stmt FROM @exesql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;
END;$$
CALL mytest();