MySQL, JSONL: An example of a MySQL query returning JSONL.

JSONL from MySQL.md

JSONL from MySQL

Given: A users table in MySQL containing the data from the file 1-users.tsv.

Running the SQL query from the file 2-mysqlJsonl.sql gives the results shown in the file 3-results.jsonl.

1-users.tsv

2-mysqlJsonl.sql

SELECT json_object(
           'username', username,
           'email', email
       ) AS json
FROM `users`

3-results.jsonl

{"username": "mike", "email": "[email protected]"}
{"username": "jane", "email": "[email protected]"}
{"username": "stan", "email": "[email protected]"}