现在将这个表导出为文本文件:c:\data_out.txt。
复制代码 代码如下:
select name,age,city,salary
into outfile “c:/data_out.txt”
lines terminated by “\r\n”
from person;
复制代码 代码如下:
select name,age,city,salary
into outfile “c:/data_out.txt”
lines terminated by “\r\n”
from person;