使用MySQL创建一个有姓名语文成绩英语成绩数学成绩的表不少于50条
以下是一个创建了具有姓名、语文成绩、英语成绩、数学成绩的表,并填充了50条数据的MySQL代码:
CREATE TABLE student_scores (
id INT NOT NULL AUTO_INCREMENT,
name VARCHAR(50) NOT NULL,
chinese_score INT NOT NULL,
english_score INT NOT NULL,
math_score INT NOT NULL,
PRIMARY KEY (id)
);
INSERT INTO student_scores (name, chinese_score, english_score, math_score) VALUES
('张三', 70, 80, 90),
('李四', 80, 70, 85),
('王五', 90, 85, 95),
('赵六', 75, 90, 80),
('钱七', 85, 75, 90),
('孙八', 90, 95, 85),
('周九', 80, 85, 90),
('吴十', 85, 80, 75),
('郑十一', 95, 90, 95),
('王十二', 90, 85, 80),
('陈十三', 80, 90, 85),
('李十四', 85, 75, 90),
('张十五', 90, 95, 85),
('刘十六', 85, 80, 75),
('李十七', 95, 90, 95),
('王十八', 90, 85, 80),
('张十九', 80, 90, 85),
('钱二十', 85, 75, 90),
('周二十一', 90, 95, 85),
('吴二十二', 85, 80, 75),
('郑二十三', 95, 90, 95),
('赵二十四', 90, 85, 80),
('王二十五', 80, 90, 85),
('李二十六', 85, 75, 90),
('张二十七', 90, 95, 85),
('孙二十八', 85, 80, 75),
('周二十九', 95, 90, 95),
('钱三十', 90, 85, 80),
('吴三十一', 80, 90, 85),
('郑三十二', 85, 75, 90),
('张三十三', 90, 95, 85),
('王三十四', 85, 80, 75),
('赵三十五', 95, 90, 95),
('李三十六', 90, 85, 80),
('孙三十七', 80, 90, 85),
('周三十八', 85, 75, 90),
('钱三十九', 90, 95, 85),
('吴四十', 85, 80, 75),
('郑四十一', 95, 90, 95),
('张四十二', 90, 85, 80),
('王四十三', 80, 90, 85),
('赵四十四', 85, 75, 90),
('李四十五', 90, 95, 85),
('孙四十六', 85, 80, 75),
('周四十七', 95, 90, 95),
('钱四十八', 90, 85, 80),
('吴四十九', 80, 90, 85),
('郑五十', 85, 75, 90);
这样就创建了一个具有50条数据的学生成绩表
原文地址: https://www.cveoy.top/t/topic/fD1S 著作权归作者所有。请勿转载和采集!