Batch import TXT into MySQL TEXT

Want to batch import TXT (Text) documents into MySQL TEXT (CLOB) column?

Try Withdata DBBlobEditor, a MySQL TEXT (CLOB) editor, Bulk import TXT into MySQL, East and Fast.

Can run in GUI mode, just a few mouse clicks.
Can run in Command line, for Scheduled Tasks and Streams.
Support Windows, Linux, and macOS.

Download DBBlobEditor

Batch import TXT documents to MySQL TEXT (CLOB) column

Run DBBlobEditor, login to MySQL.

Batch import txt files into MySQL TEXT (CLOB) - login to MySQL

Click “Start New Task – Import LOB From Files” at task dialog.

Batch import txt files into MySQL TEXT (CLOB) - Task Window

then show the wizard.

1. Configure import TXT settings.

Batch insert txt files into MySQL TEXT (CLOB) - config

2. Bulk import TXT files to MySQL TEXT (CLOB).

Batch save txt files into MySQL TEXT (CLOB) - import

then you can see importing results

Batch import txt files into MySQL TEXT (CLOB) - view

More about MySQL TEXT (CLOB) importer

Download Withdata DBBlobEditor

TXT → MySQL reference

Type mapping

Value kind	in TXT	in MySQL
Int	`1234, or right-aligned in a fixed-width column`	`INT`
Bigint	`9007199254740993`	`BIGINT`
Decimal	`1234.56`	`DECIMAL(p,s)`
Float	`1.234e+10`	`DOUBLE`
Text	`written as-is; padding depends on the chosen layout`	`VARCHAR(n)`
Long text	`written as-is`	`LONGTEXT`
Date	`whatever the writer chose`	`DATE`
Datetime	`whatever the writer chose`	`DATETIME`
Binary	`not representable`	`LONGBLOB`
Boolean	`Y / N, or 1 / 0, or TRUE / FALSE`	`TINYINT(1)`
JSON	`written as-is`	`JSON`

Dialect differences

TXT is a file format and MySQL is a database server, so the target has to be told the types the file never carried – the rows below are where the two sides diverge.

Property	in TXT	in MySQL
port	`—`	`3306`
identifiers	`None by convention`	`backtick`
row limit	`—`	`LIMIT n`
dates	`Whatever the writer produced; no convention is guaranteed`	`DATETIME, TIMESTAMP, DATE, TIME`
long text	`—`	`TINYTEXT / TEXT / MEDIUMTEXT / LONGTEXT`
binary	`Not supported`	`BLOB / TINYBLOB / LONGBLOB`
separator	`Whatever was chosen - often fixed column widths`	`—`
encoding	`No declaration - UTF-8 works only with a BOM`	`—`
typing	`None - every field is text`	`—`
shape	`Free form; a parser has to be told the layout`	`Tables of rows and columns`
ceiling	`No formal limit`	`—`

Command line

Side	Command
MySQL	`mysqldump, or mysql -e "SELECT ..." > out.csv`
MySQL (load)	`mysqlimport, or LOAD DATA INFILE`

Convert your data online, free

Free in-browser converters for CSV, Excel, JSON, XML and SQL: Withdata Online Data Conversion. Large files, batch conversion or scheduling? See the offline desktop apps, or browse all data conversion tools.