导入txt文件:
1 按照txt文件的结构在数据库里先创建一个表:
create table dpaj(ID INT AUTO_INCREMENT PRIMARY KEY,AJLB VARCHAR(100),AQMS TEXT);
2.load data local infile 'e:/class1.txt' into table dpaj(AJLB,AQMS);
导出txt文件:
select XXDZ from place_dict where QU like '%新洲区%' into outfile 'E:/Users/Administrator/workspace/FeatureExtract/file/xinzhou.txt';