但如果要将分隔的文本文件导入到db，则可以使用 LOAD DATA INFILE 如下：

  LOAD DATA INFILE'/path/file.txt'
 INTO TABLE tablename 
由'|'终止的字段
由'\\\
'终止的行
 IGNORE 1 LINES; 
 

UPDATE：

首先，你需要创建表（如果还没有完成）：

  CREATE TABLE`tablename `（
`FEATURE_ID` int（11）unsigned NOT NULL，
`FEATURE_NAME` varchar（512）DEFAULT NULL，
`FEATURE_CLASS` varchar（512）DEFAULT NULL，
 PRIMARY KEY（`FEATURE_ID`）
）
 

您可能需要调整数据类型，和对该表的约束。例如，您可能不需要该表上的PK。

I was wondering how to import text file into MySQL workbench?

I have a text file delimited by | and the first row are the tables,

FEATURE_ID|FEATURE_NAME|FEATURE_CLASS

then it follows by data information after that

1388627|Etena|Populated Place

What is the best way to import this .txt file into MySQL workbench?

Thanks1

It's not clear what exactly you intend to achieve, but if you want to import delimited text file into db then you can use LOAD DATA INFILE like this:

LOAD DATA INFILE '/path/file.txt' 
INTO TABLE tablename 
FIELDS TERMINATED BY '|'
LINES TERMINATED BY '\n'
IGNORE 1 LINES;

UPDATE:

First of cause you need to create the table (if it's not done yet) like this:

CREATE TABLE `tablename` (
  `FEATURE_ID` int(11) unsigned NOT NULL,
  `FEATURE_NAME` varchar(512) DEFAULT NULL,
  `FEATURE_CLASS` varchar(512) DEFAULT NULL,
  PRIMARY KEY (`FEATURE_ID`)
)

You might need to adjust data types, lengths, and constraints on that table. For example you might not need a PK on that table.