更新:select b,c from table1 into outfile 'test.txt' fields terminated by '#'; 另外,你要得是导入还是导出啊?
select b,c from table1 into outfile 'yourdata.txt'; 就行了。 另有可选参数: fields terminated by 指定了字段结束的符号(默认是\t); escaped by 用来跳过特殊的字符(默认是反斜线); enclosed by 指定包围字段值的符号。 例如:select b,c from table1 into outfile 'yourdata.txt' fields terminated by ',' enclosed by '"' lines terminated by '\r\n';
另外,你要得是导入还是导出啊?
另有可选参数:
fields terminated by 指定了字段结束的符号(默认是\t);
escaped by 用来跳过特殊的字符(默认是反斜线);
enclosed by 指定包围字段值的符号。
例如:select b,c from table1 into outfile 'yourdata.txt' fields terminated by ',' enclosed
by '"' lines terminated by '\r\n';