Man page - apop_text_to_db(1)

Packages contains this manual

Package: apophenia-bin
apt-get install apophenia-bin

Manuals in package:

Documentations in package:

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.

	-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