比如数据库表Test有两列Test(Time,Class).
现有一日志文件:[2011-10-23 10:10:10][Control]
[2011-10-23 10:10:12][Agent]
[2011-10-23 10:10:14][Command]
......
怎么用LOAD DTA INFILE导入数据时将[ ] 去掉,即:Time Class2011-10-23 10:10:10 Control
2011-10-23 10:10:12 Agent
2011-10-23 10:10:14 Command
现有一日志文件:[2011-10-23 10:10:10][Control]
[2011-10-23 10:10:12][Agent]
[2011-10-23 10:10:14][Command]
......
怎么用LOAD DTA INFILE导入数据时将[ ] 去掉,即:Time Class2011-10-23 10:10:10 Control
2011-10-23 10:10:12 Agent
2011-10-23 10:10:14 Command
[[OPTIONALLY] ENCLOSED BY 'char']
试一下这两个参数的指定。