在建好的学生表中插入100条数据
时间: 2023-08-07 12:05:24 浏览: 51
好的,以下是向学生表中插入 100 条数据的 SQL 语句:
```
INSERT INTO student (name, age, gender, grade) VALUES
('张三', 18, 'male', 1),
('李四', 19, 'male', 2),
('王五', 20, 'male', 3),
('赵六', 21, 'female', 4),
('钱七', 22, 'female', 2),
('孙八', 23, 'male', 1),
('周九', 24, 'female', 3),
('吴十', 25, 'male', 4),
('郑一', 18, 'male', 3),
('王二', 19, 'female', 2),
('陈三', 20, 'male', 1),
('杨四', 21, 'male', 4),
('赵五', 22, 'female', 3),
('黄六', 23, 'female', 2),
('吴七', 24, 'male', 1),
('周八', 25, 'male', 4),
('郑九', 18, 'male', 2),
('王十', 19, 'female', 3),
('张十一', 20, 'male', 3),
('李十二', 21, 'male', 4),
('王十三', 22, 'female', 2),
('赵十四', 23, 'female', 1),
('钱十五', 24, 'male', 4),
('孙十六', 25, 'male', 2),
('周十七', 18, 'male', 3),
('吴十八', 19, 'female', 2),
('郑十九', 20, 'male', 1),
('王二十', 21, 'male', 4),
('陈二十一', 22, 'female', 3),
('杨二十二', 23, 'female', 2),
('赵二十三', 24, 'male', 1),
('黄二十四', 25, 'male', 4),
('吴二十五', 18, 'male', 3),
('周二十六', 19, 'female', 2),
('郑二十七', 20, 'male', 1),
('王二十八', 21, 'male', 4),
('张二十九', 22, 'female', 3),
('李三十', 23, 'female', 2),
('王三十一', 24, 'male', 1),
('赵三十二', 25, 'male', 4),
('钱三十三', 18, 'male', 3),
('孙三十四', 19, 'female', 2),
('周三十五', 20, 'male', 1),
('吴三十六', 21, 'male', 4),
('郑三十七', 22, 'female', 3),
('王三十八', 23, 'female', 2),
('陈三十九', 24, 'male', 1),
('杨四十', 25, 'male', 4),
('赵四十一', 18, 'male', 3),
('黄四十二', 19, 'female', 2),
('吴四十三', 20, 'male', 1),
('周四十四', 21, 'male', 4),
('郑四十五', 22, 'female', 3),
('王四十六', 23, 'female', 2),
('张四十七', 24, 'male', 1),
('李四十八', 25, 'male', 4),
('赵四十九', 18, 'male', 3),
('钱五十', 19, 'female', 2),
('孙五十一', 20, 'male', 1),
('周五十二', 21, 'male', 4),
('吴五十三', 22, 'female', 3),
('郑五十四', 23, 'female', 2),
('王五十五', 24, 'male', 1),
('陈五十六', 25, 'male', 4),
('杨五十七', 18, 'male', 3),
('赵五十八', 19, 'female', 2),
('黄五十九', 20, 'male', 1),
('吴六十', 21, 'male', 4),
('周六十一', 22, 'female', 3),
('郑六十二', 23, 'female', 2),
('王六十三', 24, 'male', 1),
('张六十四', 25, 'male', 4),
('李六十五', 18, 'male', 3),
('赵六十六', 19, 'female', 2),
('钱六十七', 20, 'male', 1),
('孙六十八', 21, 'male', 4),
('周六十九', 22, 'female', 3),
('吴七十', 23, 'female', 2),
('郑七十一', 24, 'male', 1),
('王七十二', 25, 'male', 4),
('张七十三', 18, 'male', 3),
('李七十四', 19, 'female', 2),
('赵七十五', 20, 'male', 1),
('黄七十六', 21, 'male', 4),
('吴七十七', 22, 'female', 3),
('周七十八', 23, 'female', 2),
('郑七十九', 24, 'male', 1),
('王八十', 25, 'male', 4);
```
这个语句会向学生表中插入 100 条记录,每条记录包含了学生的姓名、年龄、性别和年级等信息。你可以根据实际需求修改数据内容。