sqlselect_to_db man page

sqlselect_to_db — convert MySQL or MariaDB selected tables to fsdb

Synopsis

sqlselect_to_db <source.sqlselect_table >dest.fsdb

Description

Converts a MySQL or MariaDB tables to Fsdb format.

The input is not fsdb. The first non-box row is taken to be the names of the columns.

The output is two-space-separated fsdb. (Someday more general field separators should be supported.)

This module also supports the standard fsdb options:

-d
Enable debugging output.
-i or --input InputSource
Read from InputSource, typically a file name, or "-" for standard input, or (if in Perl) a IO::Handle, Fsdb::IO or Fsdb::BoundedQueue objects.
-o or --output OutputDestination
Write to OutputDestination, typically a file name, or "-" for standard output, or (if in Perl) a IO::Handle, Fsdb::IO or Fsdb::BoundedQueue objects.
--autorun or --noautorun
By default, programs process automatically, but Fsdb::Filter objects in Perl do not run until you invoke the run() method. The "--(no)autorun" option controls that behavior within Perl.
--help
Show help.
--man
Show full manual.

Sample Usage

Input

+----------------+---------------+--------------------+------+-------------------------+
| username       | firstname     | lastname           | id   | email                   |
+----------------+---------------+--------------------+------+-------------------------+
| johnh          | John          | Heidemann          |  134 | johnh@isi.edu           |
+----------------+---------------+--------------------+------+-------------------------+
1 row in set (0.01 sec)

Command

sqlselect_to_db

Output

#fsdb -F S username firstname lastname id email
johnh  John  Heidemann  134  johnh@isi.edu
#   | sqlselect_to_db

See Also

Fsdb. db_to_csv.

Info

2016-11-30 perl v5.24.0 User Contributed Perl Documentation