Man pages sections > man1 > apop_text_to_db

apop_text_to_db - command line utility to convert a text file into a database

APOP_TEXT_TO_DB(1) Apophenia APOP_TEXT_TO_DB(1)

NAME

apop_text_to_db - command line utility to convert a text file into a database table

SYNOPSIS

apop_text_to_db [ -d delimiters] text_file table_name dbname

DESCRIPTION

If the input text file name is a single dash, -, then read from STDIN. Input must be plain ASCII or UTF-8.
-d
the single-character delimiters to use, e.g., -d " ," or -d "\t" (which you will almost certainly have to write as -d "\\t") (default: "|,\t", meaning that any of a pipe, comma, or tab will delimit separate entries)
-nc
data does not include column names
-n regex
case-insensitive regular expression indicating Null values (default: NaN)
-m
use a MySQL database (default: SQLite)
-f
fixed width field ends: -f"3,8,12,17" (first char is one, not zero)
-u
mysql username
-p
mysql password
-r
data includes row names
-v
verbosity
-N
a comma-separated list of column names: -N"apple,banana,carrot,durian"
-en
if table exists, do nothing and exit
-ed
if table exists, retain the table, delete all data, refill with the new data (i.e., call 'delete * from your_table')
-eo
if table exists, overwrite the table from scratch (deleting the previous table entirely)
-ea
if table exists, append new data to the existing table
-h
display this help and exit
August 2017 Apophenia (Debian )