sqlselect_to_db - convert MySQL or MariaDB selected tables to fsdb
sqlselect_to_db <source.sqlselect_table >dest.fsdb
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:
Enable debugging output.
Read from InputSource, typically a file name, or - for standard input, or (if in Perl) a IO::Handle, Fsdb::IO or Fsdb::BoundedQueue objects.
-
Write to OutputDestination, typically a file name, or - for standard output, or (if in Perl) a IO::Handle, Fsdb::IO or Fsdb::BoundedQueue objects.
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.
--(no)autorun
Show help.
Show full manual.
+----------------+---------------+--------------------+------+-------------------------+ | username | firstname | lastname | id | email | +----------------+---------------+--------------------+------+-------------------------+ | johnh | John | Heidemann | 134 | johnh@isi.edu | +----------------+---------------+--------------------+------+-------------------------+ 1 row in set (0.01 sec)
sqlselect_to_db
#fsdb -F S username firstname lastname id email johnh John Heidemann 134 johnh@isi.edu # | sqlselect_to_db
Fsdb. db_to_csv.
$filter = new Fsdb::Filter::csv_to_db(@arguments);
Create a new csv_to_db object, taking command-line arguments.
$filter->set_defaults();
Internal: set up defaults.
$filter->parse_options(@ARGV);
Internal: parse command-line arguments.
$filter->setup();
Internal: setup, parse headers.
$filter->run();
Internal: run over each rows.
Copyright (C) 2014-2018 by John Heidemann <johnh@isi.edu>
This program is distributed under terms of the GNU general public license, version 2. See the file COPYING with the distribution for details.
To install Fsdb, copy and paste the appropriate command in to your terminal.
cpanm
cpanm Fsdb
CPAN shell
perl -MCPAN -e shell install Fsdb
For more information on module installation, please visit the detailed CPAN module installation guide.