Scroll to navigation



apop_text_to_db - 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
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
December 2021 Apophenia (Debian )