回答編集履歴
4
修正
answer
CHANGED
|
@@ -43,11 +43,11 @@
|
|
|
43
43
|
`STATIONS`
|
|
44
44
|
ON
|
|
45
45
|
`ARTICLES`.`station_id` = `STATIONS`.`id`
|
|
46
|
-
|
|
46
|
+
LEFT JOIN
|
|
47
47
|
`LINK_LINE_STATION`
|
|
48
48
|
ON
|
|
49
49
|
`STATIONS`.`id` = `LINK_LINE_STATION`.`staion_id`
|
|
50
|
-
|
|
50
|
+
LEFT JOIN
|
|
51
51
|
`LINES`
|
|
52
52
|
ON
|
|
53
53
|
`LINK_LINE_STATION`.`line_id` = `LINES`.`id`
|
3
追記
answer
CHANGED
|
@@ -29,4 +29,28 @@
|
|
|
29
29
|
`staion_name` varchar(255) DEFAULT NULL,
|
|
30
30
|
PRIMARY KEY (`id`)
|
|
31
31
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
|
|
32
|
+
```
|
|
33
|
+
|
|
34
|
+
```sql
|
|
35
|
+
SELECT
|
|
36
|
+
`ARTICLES`.`id`
|
|
37
|
+
, `ARTICLES`.`content`
|
|
38
|
+
, `STATIONS`.`station_name`
|
|
39
|
+
, `LINES`.`line_name`
|
|
40
|
+
FROM
|
|
41
|
+
`ARTICLES`
|
|
42
|
+
INNER JOIN
|
|
43
|
+
`STATIONS`
|
|
44
|
+
ON
|
|
45
|
+
`ARTICLES`.`station_id` = `STATIONS`.`id`
|
|
46
|
+
INNER JOIN
|
|
47
|
+
`LINK_LINE_STATION`
|
|
48
|
+
ON
|
|
49
|
+
`STATIONS`.`id` = `LINK_LINE_STATION`.`staion_id`
|
|
50
|
+
INNER JOIN
|
|
51
|
+
`LINES`
|
|
52
|
+
ON
|
|
53
|
+
`LINK_LINE_STATION`.`line_id` = `LINES`.`id`
|
|
54
|
+
WHERE
|
|
55
|
+
`LINES`.`line_name` LIKE '%路線名%'
|
|
32
56
|
```
|
2
tuiki
answer
CHANGED
|
File without changes
|
1
追記
answer
CHANGED
|
@@ -1,4 +1,4 @@
|
|
|
1
|
-
自分だったら、基本的には、以下のように設計します。
|
|
1
|
+
自分だったら、基本的には、以下のように設計します。インデックスとかは省略してます。
|
|
2
2
|
|
|
3
3
|
```sql
|
|
4
4
|
CREATE TABLE `ARTICLES` (
|