随笔分类 - sql

摘要：select count(1) from syscat.tables where tabname='T1'; 阅读全文

posted @ 2017-01-16 18:27 一个大洋葱阅读(364) 评论(0) 推荐(0)

摘要：SHELL脚本导入导出数据时，按逗号分隔，引号包含字段，null值'' gccli -uroot -h$ip -e"rmt:${sqlStr} into outfile '${name}${datetimes}.txt' fields terminated by ',' enclosed by '\ 阅读全文

posted @ 2017-01-13 17:28 一个大洋葱阅读(227) 评论(0) 推荐(0)