导入文本文件到mysql工作台？ [英] import text file into mysql workbench?

问题描述

我想知道如何将文本文件导入MySQL工作台？

我有一个由 | 和第一行是表格，

  FEATURE_ID | FEATURE_NAME | FEATURE_CLASS 
  

然后是数据信息，之后

  1388627 | Etena |人口稠密的地方
  

将.txt文件导入MySQL工作台最好的方法是什么？ / p>

感谢1

解决方案

但如果要将分隔的文本文件导入到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.

这篇关于导入文本文件到mysql工作台？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！