質問編集履歴

2

誤字

2021/12/15 07:37

投稿

yoto009
yoto009

スコア9

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 skill'),'users.user_id','=','favorites.user_id')
117
+ ->join(DB::raw('mysql_2.favorites AS favorite'),'user.user_id','=','favorite.user_id')
118
118
 
119
119
 
120
120
 

1

追加依頼があったので追加

2021/12/15 07:37

投稿

yoto009
yoto009

スコア9

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
+ ```