默认分隔符`\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,唱歌:喜欢-跳舞:非常喜欢-游泳:一般
```
