APOP_TEXT_TO_DB(1)

💖 NAME 💖

okay so bestie, welcome to APOP_TEXT_TO_DB(1), straight outta the Apophenia manual, and it's giving command-line main character energy ✨

apop_text_to_db — it's a command line utility that converts a text file into a database table. literally that's the whole job. and it ate. 💅

---

🦋 SYNOPSIS 🦋

apop_text_to_db [-d delimiters] text_file table_name dbname

---

✨ DESCRIPTION ✨

so here's the vibe: if the input text file name is a single dash, -, then it reads from STDIN instead. and your input has to be plain ASCII or UTF-8, no cap. 👑

🎀 the flags, bestie 🎀

• -d — the single-character delimiters to use, like -d " ," or -d "\t" (which, fr fr, you will almost certainly have to write as -d "\\t"). default: "|,\t", meaning any pipe, comma, or tab will delimit separate entries. 🌈
• -nc — nope, the data does not include column names 🙈
• -n regex — a case-insensitive regular expression indicating Null values (default: NaN)
• -m — use a MySQL database (default: SQLite)
• -f — fixed width field ends, like -f"3,8,12,17" — heads up: the first char is one, not zero 👀
• -u — mysql username
• -p — mysql password
• -r — the data includes row names
• -v — verbosity (spill the tea, tell us everything 🫖)
• -N — a comma-separated list of column names, like -N"apple,banana,carrot,durian" 🍓
• -en — if the table exists, do nothing and exit (peace out ✌️)
• -ed — if the table exists, retain the table, delete all data, and refill with the new data (i.e., call 'delete * from your_table')
• -eo — if the table exists, overwrite the table from scratch (deleting the previous table entirely 😭)
• -ea — if the table exists, append new data to the existing table
• -h — display this help and exit 💖

quick vibe check: -eo is the nuclear one — it deletes the previous table entirely. -ed keeps the table but wipes every row. choose wisely, bestie 💀

---

🌸 that's the whole page, you understood it perfectly, I'm so proud of you 🫶 this was written by the Apophenia girlies and it's from the Debian build, dated January 2026 — periodt 💅✨