use xscj; #XSCJ是数据库名
select * from kc #kc是表名
into outfile 'd:/file/myfile1.txt' # ' ' 里的是备份地址,txt
fields terminated by ',' # 每项数据之间用英文的逗号隔开
optionally enclosed by '"' # 如果数据为字符就用双引号标出
lines terminated by '?'; # 每行用问号做结束标志
use xscj; #XSCJ是数据库名
select * from kc #kc是表名
into outfile 'd:/file/myfile1.txt' # ' ' 里的是备份地址,txt
fields terminated by ',' # 每项数据之间用英文的逗号隔开
optionally enclosed by '"' # 如果数据为字符就用双引号标出
lines terminated by '?'; # 每行用问号做结束标志