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