4.在放映表(showings),包括放映的 ID、所属电影、所属放映厅、时间、票价等信息中利用sql语句插入数据并进行相关查询语句操作
时间: 2023-12-23 11:06:22 浏览: 28
好的,以下是对应的 SQL 语句:
创建表 showings:
```
CREATE TABLE showings (
id INT PRIMARY KEY,
movie_id INT NOT NULL,
hall_id INT NOT NULL,
showtime DATETIME NOT NULL,
price DECIMAL(5, 2) NOT NULL,
FOREIGN KEY (movie_id) REFERENCES movies(id),
FOREIGN KEY (hall_id) REFERENCES halls(id)
);
```
插入数据:
```
INSERT INTO showings (id, movie_id, hall_id, showtime, price)
VALUES
(1, 1, 1, '2022-01-01 14:00:00', 40.00),
(2, 1, 1, '2022-01-01 16:30:00', 40.00),
(3, 1, 1, '2022-01-01 19:00:00', 45.00),
(4, 1, 2, '2022-01-02 14:00:00', 35.00),
(5, 1, 2, '2022-01-02 16:30:00', 35.00),
(6, 1, 2, '2022-01-02 19:00:00', 40.00),
(7, 2, 3, '2022-01-03 14:00:00', 45.00),
(8, 2, 3, '2022-01-03 16:30:00', 45.00),
(9, 2, 3, '2022-01-03 19:00:00', 50.00),
(10, 2, 4, '2022-01-04 14:00:00', 50.00),
(11, 2, 4, '2022-01-04 16:30:00', 50.00),
(12, 2, 4, '2022-01-04 19:00:00', 55.00);
```
查询所有放映的信息:
```
SELECT * FROM showings;
```
查询所属电影为“流浪地球”的放映信息:
```
SELECT * FROM showings WHERE movie_id = 1;
```
查询所属放映厅为“2号厅”、时间为“2022-01-02 16:30:00”的放映信息:
```
SELECT * FROM showings WHERE hall_id = 2 AND showtime = '2022-01-02 16:30:00';
```