質問編集履歴

1

補足情報

2017/05/01 11:12

投稿

JunZenpou
JunZenpou

スコア24

test CHANGED
File without changes
test CHANGED
@@ -172,4 +172,38 @@
172
172
 
173
173
  ###補足情報(言語/FW/ツール等のバージョンなど)
174
174
 
175
+ ```sqlLog
176
+
175
- より詳細な情報
177
+ SELECT
178
+
179
+ Posts.id AS `Posts__id`,
180
+
181
+ Posts.user_id AS `Posts__user_id`,
182
+
183
+ Posts.body AS `Posts__body`,
184
+
185
+ Posts.created AS `Posts__created`,
186
+
187
+ Users.id AS `Users__id`,
188
+
189
+ Users.name AS `Users__name`,
190
+
191
+ Users.username AS `Users__username`,
192
+
193
+ Users.password AS `Users__password`,
194
+
195
+ Users.password2 AS `Users__password2`,
196
+
197
+ Users.email AS `Users__email`
198
+
199
+ FROM
200
+
201
+ posts Posts
202
+
203
+ LEFT JOIN users Users ON Users.id = (Posts.user_id)
204
+
205
+
206
+
207
+ ```
208
+
209
+ SQLのLogはこのように出ています。