import text file into mysql workbench?

Question

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

Do you want to import data into mysql db? Or something else? — peterm, Jan 14 '13 at 05:43
but how exactly do I do so? If my file shows the tables in the first row and then follow data after that? — hellomello, Jan 14 '13 at 08:22
Just create that table (see updated answer) version. If columns in file and in the table match than it will load successfully with `LOAD DATA INFILE` statement that I gave. — peterm, Jan 15 '13 at 04:26
possible duplicate of [How to import a csv file into MySQL workbench?](http://stackoverflow.com/questions/11429827/how-to-import-a-csv-file-into-mysql-workbench) — Deanna, Mar 30 '15 at 15:46

peterm · Accepted Answer · 2013-01-15T04:23:45.463

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.

Maybe I just follow this and just write in the column names myself? — hellomello, Jan 15 '13 at 04:00

import text file into mysql workbench?

1 Answers1

Linked