Slide 54
Slide 54 text
JSON_TABLE関数
SELECT DISTINCT tweet_id, LEFT(REPLACE(text, '\n', '\\n'), 16) AS
text
FROM t2, JSON_TABLE(t2.j, '$.statuses[*]' COLUMNS
(
tweet_id NUMERIC(32) PATH '$.id',
text VARCHAR(300) PATH '$.text'
)
) AS json;
+---------------------+----------------------+
| tweet_id | text |
+---------------------+----------------------+
| 1131026738492739584 | @ikaneko MySQLメイ |
| 1131025041070497792 | LAMP環境\n\nLinux, |
| 1131024962121281536 | RT @OracleDev_JP |
| 1131026921276317697 | RT @sirius_gener |
+---------------------+----------------------+
4 rows in set (0.00 sec)
53/118