Slide 65
Slide 65 text
データ検証
実行結果
65
mysql> SELECT
-> users.nickname,
-> users.email,
-> uploads.created
-> FROM
-> users
-> INNER JOIN
-> (
-> SELECT
-> user_id,
-> MAX(created) as created
-> FROM
-> uploads
-> GROUP BY
-> user_id
-> ) as uploads
-> ON users.id = uploads.user_id
-> WHERE
-> users.id = 2177557
-> ORDER BY
-> uploads.created DESC;
+------------------+----------------------------+---------------------+
| nickname | email | created |
+------------------+----------------------------+---------------------+
| nickname_2177557 | test+2177557@lancers.co.jp | 2020-04-17 16:16:21 |
+------------------+----------------------------+---------------------+
1 row in set (1.30 sec)