这个是对的 把文本数据 导入到数据库中 是对的
LOAD DATA INFILE 'C:/access_20130719.log' INTO TABLE log
FIELDS TERMINATED BY ' ' OPTIONALLY ENCLOSED BY '"' ESCAPED BY '\\';
下面就是要导入数据了。进入mysql的shell中
LOAD DATA INFILE "/data0/log.txt" INTO TABLE apache_log FIELDS TERMINATED BY " " LINES TERMINATED BY '\n';
#TERMINATED BY " "表示用空格区分分每项
#LINES TERMINATED BY '\n'表示用换行区分每列
#TERMINATED BY " "表示用空格区分分每项