> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-fix-nav-issues.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.
> TSKV 포맷 문서
# TSKV
| 입력 | 출력 | 별칭 |
| -- | -- | -- |
| ✔ | ✔ | |
## 설명
[`TabSeparated`](/ko/reference/formats/TabSeparated/TabSeparated) 포맷과 비슷하지만, 값을 `name=value` 포맷으로 출력합니다.
이름은 [`TabSeparated`](/ko/reference/formats/TabSeparated/TabSeparated) 포맷과 같은 방식으로 이스케이프되며, `=` 기호도 이스케이프됩니다.
```text theme={null}
SearchPhrase= count()=8267016
SearchPhrase=bathroom interior design count()=2166
SearchPhrase=clickhouse count()=1655
SearchPhrase=2014 spring fashion count()=1549
SearchPhrase=freeform photos count()=1480
SearchPhrase=angelina jolie count()=1245
SearchPhrase=omsk count()=1112
SearchPhrase=photos of dog breeds count()=1091
SearchPhrase=curtain designs count()=1064
SearchPhrase=baku count()=1000
```
```sql title="Query" theme={null}
SELECT * FROM t_null FORMAT TSKV
```
```text title="Response" theme={null}
x=1 y=\N
```
작은 컬럼이 매우 많은 경우 이 포맷은 비효율적이며, 일반적으로 사용할 이유가 없습니다.
그럼에도 효율성 측면에서는 [`JSONEachRow`](/ko/reference/formats/JSON/JSONEachRow) 포맷보다 나쁘지 않습니다.
파싱 시 서로 다른 컬럼의 값은 순서와 관계없이 처리할 수 있습니다.
일부 값은 생략해도 되며, 이 경우 해당 값은 기본값으로 처리됩니다.
이 경우 0과 빈 행이 기본값으로 사용됩니다.
테이블에서 지정할 수 있는 복합 값은 기본값으로 지원되지 않습니다.
파싱 시 등호나 값 없이 추가 필드 `tskv`를 넣을 수 있습니다. 이 필드는 무시됩니다.
가져오는 동안 알 수 없는 이름의 컬럼은 건너뜁니다.
단, 설정 [`input_format_skip_unknown_fields`](/ko/reference/settings/formats#input_format_skip_unknown_fields)가 `1`로 설정되어 있어야 합니다.
[NULL](/ko/reference/syntax)은 `\N`으로 표현됩니다.
## 사용 예시
### 데이터 삽입
`football.tskv`라는 이름의 다음 tskv 파일을 사용합니다:
```tsv theme={null}
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
```
데이터를 삽입합니다:
```sql theme={null}
INSERT INTO football FROM INFILE 'football.tskv' FORMAT TSKV;
```
### 데이터 읽기
`TSKV` 포맷을 사용해 데이터를 읽습니다:
```sql theme={null}
SELECT *
FROM football
FORMAT TSKV
```
출력은 컬럼 이름과 타입을 나타내는 2개의 헤더 행이 포함된 탭으로 구분된 포맷입니다:
```tsv theme={null}
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
```
## 포맷 설정