apop_text_to_db(1) command line utility to convert a text file into a database table


apop_text_to_db [,-d delimiters/] ,text_file table_name dbname/


If the input text file name is a single dash, -, then read from STDIN. Input must be plain ASCII or UTF-8.
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)
data does not include column names
-n regex
case-insensitive regular expression indicating Null values (default: NaN)
use a MySQL database (default: SQLite)
fixed width field ends: -f"3,8,12,17" (first char is one, not zero)
mysql username
mysql password
data includes row names
a comma-separated list of column names: -N"apple,banana,carrot,durian"
if table exists, do nothing and exit
if table exists, retain the table, delete all data, refill with the new data (i.e., call 'delete * from your_table')
if table exists, overwrite the table from scratch (deleting the previous table entirely)
if table exists, append new data to the existing table
display this help and exit