PrettyJSONEachRow
| 输入 | 输出 | 别名 |
|---|---|---|
| ✗ | ✔ | PrettyJSONLines, PrettyNDJSON |
描述
与 JSONEachRow 的唯一区别在于，JSON 采用带换行符和四个空格缩进的美化格式。
使用示例
插入数据
使用包含以下数据的 JSON 文件，并将其命名为 football.json：
{
"date": "2022-04-30",
"season": 2021,
"home_team": "Sutton United",
"away_team": "Bradford City",
"home_team_goals": 1,
"away_team_goals": 4
}
{
"date": "2022-04-30",
"season": 2021,
"home_team": "Swindon Town",
"away_team": "Barrow",
"home_team_goals": 2,
"away_team_goals": 1
}
{
"date": "2022-04-30",
"season": 2021,
"home_team": "Tranmere Rovers",
"away_team": "Oldham Athletic",
"home_team_goals": 2,
"away_team_goals": 0
}
{
"date": "2022-05-02",
"season": 2021,
"home_team": "Port Vale",
"away_team": "Newport County",
"home_team_goals": 1,
"away_team_goals": 2
}
{
"date": "2022-05-02",
"season": 2021,
"home_team": "Salford City",
"away_team": "Mansfield Town",
"home_team_goals": 2,
"away_team_goals": 2
}
{
"date": "2022-05-07",
"season": 2021,
"home_team": "Barrow",
"away_team": "Northampton Town",
"home_team_goals": 1,
"away_team_goals": 3
}
{
"date": "2022-05-07",
"season": 2021,
"home_team": "Bradford City",
"away_team": "Carlisle United",
"home_team_goals": 2,
"away_team_goals": 0
}
{
"date": "2022-05-07",
"season": 2021,
"home_team": "Bristol Rovers",
"away_team": "Scunthorpe United",
"home_team_goals": 7,
"away_team_goals": 0
}
{
"date": "2022-05-07",
"season": 2021,
"home_team": "Exeter City",
"away_team": "Port Vale",
"home_team_goals": 0,
"away_team_goals": 1
}
{
"date": "2022-05-07",
"season": 2021,
"home_team": "Harrogate Town A.F.C.",
"away_team": "Sutton United",
"home_team_goals": 0,
"away_team_goals": 2
}
{
"date": "2022-05-07",
"season": 2021,
"home_team": "Hartlepool United",
"away_team": "Colchester United",
"home_team_goals": 0,
"away_team_goals": 2
}
{
"date": "2022-05-07",
"season": 2021,
"home_team": "Leyton Orient",
"away_team": "Tranmere Rovers",
"home_team_goals": 0,
"away_team_goals": 1
}
{
"date": "2022-05-07",
"season": 2021,
"home_team": "Mansfield Town",
"away_team": "Forest Green Rovers",
"home_team_goals": 2,
"away_team_goals": 2
}
{
"date": "2022-05-07",
"season": 2021,
"home_team": "Newport County",
"away_team": "Rochdale",
"home_team_goals": 0,
"away_team_goals": 2
}
{
"date": "2022-05-07",
"season": 2021,
"home_team": "Oldham Athletic",
"away_team": "Crawley Town",
"home_team_goals": 3,
"away_team_goals": 3
}
{
"date": "2022-05-07",
"season": 2021,
"home_team": "Stevenage Borough",
"away_team": "Salford City",
"home_team_goals": 4,
"away_team_goals": 2
}
{
"date": "2022-05-07",
"season": 2021,
"home_team": "Walsall",
"away_team": "Swindon Town",
"home_team_goals": 0,
"away_team_goals": 3
}
插入数据：
INSERT INTO football FROM INFILE 'football.json' FORMAT PrettyJSONEachRow;
读取数据
以 PrettyJSONEachRow 格式读取数据：
SELECT *
FROM football
FORMAT PrettyJSONEachRow
输出结果将为 JSON 格式：
{
"date": "2022-04-30",
"season": 2021,
"home_team": "Sutton United",
"away_team": "Bradford City",
"home_team_goals": 1,
"away_team_goals": 4
}
{
"date": "2022-04-30",
"season": 2021,
"home_team": "Swindon Town",
"away_team": "Barrow",
"home_team_goals": 2,
"away_team_goals": 1
}
{
"date": "2022-04-30",
"season": 2021,
"home_team": "Tranmere Rovers",
"away_team": "Oldham Athletic",
"home_team_goals": 2,
"away_team_goals": 0
}
{
"date": "2022-05-02",
"season": 2021,
"home_team": "Port Vale",
"away_team": "Newport County",
"home_team_goals": 1,
"away_team_goals": 2
}
{
"date": "2022-05-02",
"season": 2021,
"home_team": "Salford City",
"away_team": "Mansfield Town",
"home_team_goals": 2,
"away_team_goals": 2
}
{
"date": "2022-05-07",
"season": 2021,
"home_team": "Barrow",
"away_team": "Northampton Town",
"home_team_goals": 1,
"away_team_goals": 3
}
{
"date": "2022-05-07",
"season": 2021,
"home_team": "Bradford City",
"away_team": "Carlisle United",
"home_team_goals": 2,
"away_team_goals": 0
}
{
"date": "2022-05-07",
"season": 2021,
"home_team": "Bristol Rovers",
"away_team": "Scunthorpe United",
"home_team_goals": 7,
"away_team_goals": 0
}
{
"date": "2022-05-07",
"season": 2021,
"home_team": "Exeter City",
"away_team": "Port Vale",
"home_team_goals": 0,
"away_team_goals": 1
}
{
"date": "2022-05-07",
"season": 2021,
"home_team": "Harrogate Town A.F.C.",
"away_team": "Sutton United",
"home_team_goals": 0,
"away_team_goals": 2
}
{
"date": "2022-05-07",
"season": 2021,
"home_team": "Hartlepool United",
"away_team": "Colchester United",
"home_team_goals": 0,
"away_team_goals": 2
}
{
"date": "2022-05-07",
"season": 2021,
"home_team": "Leyton Orient",
"away_team": "Tranmere Rovers",
"home_team_goals": 0,
"away_team_goals": 1
}
{
"date": "2022-05-07",
"season": 2021,
"home_team": "Mansfield Town",
"away_team": "Forest Green Rovers",
"home_team_goals": 2,
"away_team_goals": 2
}
{
"date": "2022-05-07",
"season": 2021,
"home_team": "Newport County",
"away_team": "Rochdale",
"home_team_goals": 0,
"away_team_goals": 2
}
{
"date": "2022-05-07",
"season": 2021,
"home_team": "Oldham Athletic",
"away_team": "Crawley Town",
"home_team_goals": 3,
"away_team_goals": 3
}
{
"date": "2022-05-07",
"season": 2021,
"home_team": "Stevenage Borough",
"away_team": "Salford City",
"home_team_goals": 4,
"away_team_goals": 2
}
{
"date": "2022-05-07",
"season": 2021,
"home_team": "Walsall",
"away_team": "Swindon Town",
"home_team_goals": 0,
"away_team_goals": 3
}
