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