SQLSELECT_TO_DB(1)

💖 sqlselect_to_db 💖

bestie, welcome to the SQLSELECT_TO_DB(1) manual from the User Contributed Perl Documentation, and it's all about sqlselect_to_db — convert MySQL or MariaDB selected tables to fsdb. no cap, it's giving useful ✨

🌸 NAME 🌸

sqlselect_to_db — convert MySQL or MariaDB selected tables to fsdb

🎀 SYNOPSIS 🎀

sqlselect_to_db <source.sqlselect_table >dest.fsdb

🦋 DESCRIPTION 🦋

okay so this cutie converts a MySQL or MariaDB tables to Fsdb format — yes, the original phrasing said "a ... tables", and I'm not gonna fix it because facts are facts 💅.

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 — manifesting that upgrade 🙏.)

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.

👑 AUTHOR and COPYRIGHT 👑

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.

---

💫 and that's the whole SQLSELECT_TO_DB(1) moment — this page is from perl v5.32.1, dated 2024-08-02. byeee bestie, slay responsibly 🫶