默認分隔符`\001`
> 在vi編輯器中先按(Ctrl + v)再按(Ctrl + a)可以打出來分隔符`\001`
```mysql
create table t3(id int, name string);
```
```
1^Azhangpn
2^Azhangpn666
3^Azhangpn888
```
指定分隔符 ①、`delimited`(大多數) ②、`serde`
```mysql
create table t3(id int, name string) row format delimited fields terminated by ',';
```
復雜類型
```mysql
create table t4(name string, address array<string>) row format delimited fields terminated by '\t' collection items terminated by ',';
```
```
Apollo ShangHai,NanJing,BeiJing,TianJin
Paul LeShan,ChengDu,SuZhou,WuXi,ChongQin
Flynn BeiJing,ShangHai,XuZhou,KunShan
```
```mysql
create table t5(id int, name string, hobby map<string,string>) row format delimited fields terminated by ',' collection items terminated by '-' map keys terminated by ':';
```
```
1,Apollo,唱歌:非常喜歡-跳舞:不喜歡-游泳:一般
2,Paul,唱歌:喜歡-跳舞:喜歡-游泳:不喜歡
3,Flynn,唱歌:喜歡-跳舞:非常喜歡-游泳:一般
```
