EnglishFrenchSpanish

Ad


OnWorks favicon

apop_text_to_db - Online in the Cloud

Run apop_text_to_db in OnWorks free hosting provider over Ubuntu Online, Fedora Online, Windows online emulator or MAC OS online emulator

This is the command apop_text_to_db that can be run in the OnWorks free hosting provider using one of our multiple free online workstations such as Ubuntu Online, Fedora Online, Windows online emulator or MAC OS online emulator

PROGRAM:

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

Use apop_text_to_db online using onworks.net services


Free Servers & Workstations

Download Windows & Linux apps

  • 1
    VBA-M (Archived - Now on Github)
    VBA-M (Archived - Now on Github)
    Project has moved to
    https://github.com/visualboyadvance-m/visualboyadvance-m
    Features:Cheat creationsave statesmulti
    system, supports gba, gbc, gb, sgb,
    sgb2Tu...
    Download VBA-M (Archived - Now on Github)
  • 2
    Stacer
    Stacer
    Linux System Optimizer and Monitoring
    Github Repository:
    https://github.com/oguzhaninan/Stacer.
    Audience: End Users/Desktop. User
    interface: Qt. Programming La...
    Download Stacer
  • 3
    OrangeFox
    OrangeFox
    Fork of TeamWinRecoveryProject(TWRP)
    with many additional functions, redesign
    and more Features:Supports Treble and
    non-Treble ROMsUp-to-date Oreo kernel,
    built...
    Download OrangeFox
  • 4
    itop - ITSM  CMDB OpenSource
    itop - ITSM CMDB OpenSource
    IT Operations Portal: a complete open
    source, ITIL, web based service
    management tool including a fully
    customizable CMDB, a helpdesk system and
    a document man...
    Download itop - ITSM CMDB OpenSource
  • 5
    Clementine
    Clementine
    Clementine is a multi-platform music
    player and library organizer inspired by
    Amarok 1.4. It has a fast and
    easy-to-use interface, and allows you to
    search and ...
    Download Clementine
  • 6
    XISMuS
    XISMuS
    ATTENTION: Cumulative update 2.4.3 has
    been released!! The update works for any
    previous 2.x.x version. If upgrading
    from version v1.x.x, please download and
    i...
    Download XISMuS
  • 7
    facetracknoir
    facetracknoir
    Modular headtracking program that
    supports multiple face-trackers, filters
    and game-protocols. Among the trackers
    are the SM FaceAPI, AIC Inertial Head
    Tracker ...
    Download facetracknoir
  • More »

Linux commands

Ad