在放映厅表(halls)包括包括放映厅的 ID、名称、所属影院等信息中利用sql语句插入数据并进行相关查询语句操作
时间: 2024-03-10 13:46:49 浏览: 12
好的,以下是对应的 SQL 语句:
创建表 halls:
```
CREATE TABLE halls (
id INT PRIMARY KEY,
name VARCHAR(50) NOT NULL,
cinema_id INT NOT NULL,
FOREIGN KEY (cinema_id) REFERENCES cinemas(id)
);
```
插入数据:
```
INSERT INTO halls (id, name, cinema_id)
VALUES
(1, '1号厅', 1),
(2, '2号厅', 1),
(3, '3号厅', 1),
(4, '1号厅', 2),
(5, '2号厅', 2),
(6, '3号厅', 2),
(7, '1号厅', 3),
(8, '2号厅', 3),
(9, '3号厅', 3),
(10, '1号厅', 4),
(11, '2号厅', 4),
(12, '3号厅', 4);
```
查询所有放映厅的信息:
```
SELECT * FROM halls;
```
查询所属影院为“万达影城”的放映厅信息:
```
SELECT * FROM halls WHERE cinema_id = 1;
```
查询放映厅名称为“2号厅”的信息:
```
SELECT * FROM halls WHERE name = '2号厅';
```
相关问题
在座位表(seats)包括座位的 ID、所属放映厅、行号、列号等信息中利用sql语句插入数据并进行相关查询语句操作
好的,以下是对应的 SQL 语句:
创建表 seats:
```
CREATE TABLE seats (
id INT PRIMARY KEY,
hall_id INT NOT NULL,
row_number INT NOT NULL,
column_number INT NOT NULL,
FOREIGN KEY (hall_id) REFERENCES halls(id)
);
```
插入数据:
```
INSERT INTO seats (id, hall_id, row_number, column_number)
VALUES
(1, 1, 1, 1),
(2, 1, 1, 2),
(3, 1, 1, 3),
(4, 1, 2, 1),
(5, 1, 2, 2),
(6, 1, 2, 3),
(7, 1, 3, 1),
(8, 1, 3, 2),
(9, 1, 3, 3),
(10, 2, 1, 1),
(11, 2, 1, 2),
(12, 2, 1, 3),
(13, 2, 2, 1),
(14, 2, 2, 2),
(15, 2, 2, 3),
(16, 2, 3, 1),
(17, 2, 3, 2),
(18, 2, 3, 3),
(19, 3, 1, 1),
(20, 3, 1, 2),
(21, 3, 1, 3),
(22, 3, 2, 1),
(23, 3, 2, 2),
(24, 3, 2, 3),
(25, 3, 3, 1),
(26, 3, 3, 2),
(27, 3, 3, 3),
(28, 4, 1, 1),
(29, 4, 1, 2),
(30, 4, 1, 3),
(31, 4, 2, 1),
(32, 4, 2, 2),
(33, 4, 2, 3),
(34, 4, 3, 1),
(35, 4, 3, 2),
(36, 4, 3, 3);
```
查询所有座位的信息:
```
SELECT * FROM seats;
```
查询所属放映厅为“1号厅”的座位信息:
```
SELECT * FROM seats WHERE hall_id = 1;
```
查询行号为“2”、列号为“2”的座位信息:
```
SELECT * FROM seats WHERE row_number = 2 AND column_number = 2;
```
4.在放映表(showings),包括放映的 ID、所属电影、所属放映厅、时间、票价等信息中利用sql语句插入数据并进行相关查询语句操作
好的,以下是对应的 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';
```