質問編集履歴
2
誤字
test
CHANGED
File without changes
|
test
CHANGED
@@ -114,7 +114,7 @@
|
|
114
114
|
|
115
115
|
DB::table(DB::raw('mysql_1.users AS user'))
|
116
116
|
|
117
|
-
->join(DB::raw('mysql_2.favorites AS
|
117
|
+
->join(DB::raw('mysql_2.favorites AS favorite'),'user.user_id','=','favorite.user_id')
|
118
118
|
|
119
119
|
|
120
120
|
|
1
追加依頼があったので追加
test
CHANGED
File without changes
|
test
CHANGED
@@ -127,3 +127,25 @@
|
|
127
127
|
Laravel 8.7
|
128
128
|
|
129
129
|
php 7.4
|
130
|
+
|
131
|
+
|
132
|
+
|
133
|
+
### 追加
|
134
|
+
|
135
|
+
```
|
136
|
+
|
137
|
+
DB::select(
|
138
|
+
|
139
|
+
DB::raw("
|
140
|
+
|
141
|
+
select x.user_id, x.name, y.name as favorite
|
142
|
+
|
143
|
+
from mysql_1.users as x
|
144
|
+
|
145
|
+
left join mysql_2.favorites as y on x.user_id = y.user_id
|
146
|
+
|
147
|
+
")
|
148
|
+
|
149
|
+
);
|
150
|
+
|
151
|
+
```
|