sql数据导出导入格式化

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 ' ' 换行符

原文地址:https://www.cnblogs.com/dayangcong/p/6283554.html