SHELL脚本导入导出数据时,按逗号分隔,引号包含字段,null值''

gccli -uroot -h$ip -e"rmt:${sqlStr} into outfile '${name}${datetimes}.txt' fields terminated by ',' enclosed by '\"' null_value '';"

FIELDS TERMINATED BY ',' 字段间分割符
OPTIONALLY ENCLOSED BY '"' 将字段包围 对数值型无效
LINES TERMINATED BY '\n' 换行符

posted on 2017-01-13 17:28  一个大洋葱  阅读(214)  评论(0编辑  收藏  举报