1SQLSELECT_TO_DB(1)    User Contributed Perl Documentation   SQLSELECT_TO_DB(1)
2
3
4

NAME

6       sqlselect_to_db - convert MySQL or MariaDB selected tables to fsdb
7

SYNOPSIS

9           sqlselect_to_db <source.sqlselect_table >dest.fsdb
10

DESCRIPTION

12       Converts a MySQL or MariaDB tables to Fsdb format.
13
14       The input is not fsdb.  The first non-box row is taken to be the names
15       of the columns.
16
17       The output is two-space-separated fsdb.  (Someday more general field
18       separators should be supported.)
19
20       This module also supports the standard fsdb options:
21
22       -d  Enable debugging output.
23
24       -i or --input InputSource
25           Read from InputSource, typically a file name, or "-" for standard
26           input, or (if in Perl) a IO::Handle, Fsdb::IO or Fsdb::BoundedQueue
27           objects.
28
29       -o or --output OutputDestination
30           Write to OutputDestination, typically a file name, or "-" for
31           standard output, or (if in Perl) a IO::Handle, Fsdb::IO or
32           Fsdb::BoundedQueue objects.
33
34       --autorun or --noautorun
35           By default, programs process automatically, but Fsdb::Filter
36           objects in Perl do not run until you invoke the run() method.  The
37           "--(no)autorun" option controls that behavior within Perl.
38
39       --help
40           Show help.
41
42       --man
43           Show full manual.
44

SAMPLE USAGE

46   Input:
47           +----------------+---------------+--------------------+------+-------------------------+
48           | username       | firstname     | lastname           | id   | email                   |
49           +----------------+---------------+--------------------+------+-------------------------+
50           | johnh          | John          | Heidemann          |  134 | johnh@isi.edu           |
51           +----------------+---------------+--------------------+------+-------------------------+
52           1 row in set (0.01 sec)
53
54   Command:
55           sqlselect_to_db
56
57   Output:
58           #fsdb -F S username firstname lastname id email
59           johnh  John  Heidemann  134  johnh@isi.edu
60           #   | sqlselect_to_db
61

SEE ALSO

63       Fsdb.  db_to_csv.
64

66       Copyright (C) 2014-2018 by John Heidemann <johnh@isi.edu>
67
68       This program is distributed under terms of the GNU general public
69       license, version 2.  See the file COPYING with the distribution for
70       details.
71
72
73
74perl v5.34.1                      2022-04-04                SQLSELECT_TO_DB(1)
Impressum