使用select … into outfile实现导出到文本文件
举例:
select * from t_dept into outfile '/u01/apps/hbk.txt'
fields terminated by '\、'
optionally enclosed by '\“'
lines starting by '\>'
terminated by '\r\n';
每条记录一行,每行记录以“>”开头,字段之间以顿号隔开,字符类型用引号括起来,
使用select … into outfile实现导出到文本文件
举例:
select * from t_dept into outfile '/u01/apps/hbk.txt'
fields terminated by '\、'
optionally enclosed by '\“'
lines starting by '\>'
terminated by '\r\n';
每条记录一行,每行记录以“>”开头,字段之间以顿号隔开,字符类型用引号括起来,