用mysql语句为刚刚创建的表随机怎加信息
时间: 2024-04-03 10:36:10 浏览: 13
好的,以下是一个简单的 MySQL 代码示例,用于向刚刚创建的表中随机插入一些信息,你可以根据实际需求进行适当修改:
```
-- 向宿舍表中插入数据
INSERT INTO dormitory (dorm_number, building, capacity) VALUES
('A101', 'Building A', 4),
('A102', 'Building A', 4),
('A103', 'Building A', 4),
('A104', 'Building A', 4),
('B201', 'Building B', 6),
('B202', 'Building B', 6),
('B203', 'Building B', 6),
('B204', 'Building B', 6),
('B205', 'Building B', 6);
-- 向学生表中插入数据
INSERT INTO student (name, gender, age, phone, dormitory_id, bed_number) VALUES
('张三', 'male', 18, '13812345678', 1, 1),
('李四', 'male', 19, '13912345678', 1, 2),
('王五', 'male', 20, '15812345678', 1, 3),
('赵六', 'male', 18, '13812345679', 1, 4),
('小红', 'female', 18, '13812345688', 2, 1),
('小明', 'male', 19, '13912345689', 2, 2),
('小刚', 'male', 20, '15812345690', 2, 3),
('小丽', 'female', 18, '13812345699', 2, 4),
('张飞', 'male', 18, '13812345677', 5, 1),
('关羽', 'male', 19, '13912345677', 5, 2),
('刘备', 'male', 20, '15812345677', 5, 3),
('貂蝉', 'female', 18, '13812345666', 6, 1),
('吕布', 'male', 18, '13812345655', 7, 1),
('大乔', 'female', 19, '13912345666', 8, 2),
('小乔', 'female', 19, '13912345677', 8, 3),
('孙权', 'male', 20, '15812345666', 9, 1);
-- 向入住信息表中插入数据
INSERT INTO check_in (student_id, dormitory_id, bed_number, check_in_time) VALUES
(1, 1, 1, NOW() - INTERVAL 10 DAY),
(2, 1, 2, NOW() - INTERVAL 9 DAY),
(3, 1, 3, NOW() - INTERVAL 8 DAY),
(4, 1, 4, NOW() - INTERVAL 7 DAY),
(5, 2, 1, NOW() - INTERVAL 6 DAY),
(6, 2, 2, NOW() - INTERVAL 5 DAY),
(7, 2, 3, NOW() - INTERVAL 4 DAY),
(8, 2, 4, NOW() - INTERVAL 3 DAY),
(9, 5, 1, NOW() - INTERVAL 2 DAY),
(10, 5, 2, NOW() - INTERVAL 1 DAY);
-- 向退宿信息表中插入数据
INSERT INTO check_out (student_id, dormitory_id, bed_number, check_out_time) VALUES
(1, 1, 1, NOW() - INTERVAL 1 DAY),
(2, 1, 2, NOW() - INTERVAL 1 DAY),
(3, 1, 3, NOW() - INTERVAL 1 DAY),
(4, 1, 4, NOW() - INTERVAL 1 DAY),
(5, 2, 1, NOW() - INTERVAL 1 DAY);
-- 向维修信息表中插入数据
INSERT INTO maintenance (dormitory_id, repairman, repair_content, repair_time) VALUES
(1, '张三', '水管破裂', NOW() - INTERVAL 2 DAY),
(1, '李四', '电灯坏了', NOW() - INTERVAL 1 DAY),
(5, '赵六', '门锁坏了', NOW() - INTERVAL 2 DAY),
(6, '小明', '水龙头漏水', NOW() - INTERVAL 3 DAY),
(7, '小刚', '窗户玻璃坏了', NOW() - INTERVAL 4 DAY),
(8, '小丽', '墙面开裂', NOW() - INTERVAL 5 DAY),
(9, '张三', '洗手池堵塞', NOW() - INTERVAL 3 DAY);
-- 向报修信息表中插入数据
INSERT INTO repair (student_id, dormitory_id, bed_number, repair_content, repair_time, status) VALUES
(1, 1, 1, '电风扇不工作', NOW() - INTERVAL 1 DAY, 'completed'),
(2, 1, 2, '床板坏了', NOW() - INTERVAL 2 DAY, 'completed'),
(5, 2, 1, '水龙头漏水', NOW() - INTERVAL 3 DAY, 'pending'),
(6, 2, 2, '门锁坏了', NOW() - INTERVAL 4 DAY, 'completed'),
(9, 5, 1, '窗户玻璃坏了', NOW() - INTERVAL 5 DAY, 'pending'),
(10, 5, 2, '墙面开裂', NOW() - INTERVAL 6 DAY, 'pending');
```
以上示例代码中,我们向学生表、宿舍表、入住信息表、退宿信息表、维修信息表、报修信息表中分别插入了一些随机数据。你可以根据实际需求进行适当修改,例如修改学生姓名、宿舍编号、入住时间等信息。