Yet Another CPAN Grep

App-MysqlUtils ( P/PE/PERLANCAR/App-MysqlUtils-0.022.tar.gz, PERLANCAR, 2022; MetaCPAN )

App-MysqlUtils/lib/App/MysqlUtils.pm ( view source; MetaCPAN )

r, you can output as JSON.

Examples:

    # by default, show as pretty text table, like in interactive mysql client
    % mysql-query DBNAME "SELECT * FROM t1"

    # show as JSON (array of hashes)

   % mysql-query DBNAME "QUERY..." --json ;# or, --format json

    # show as CSV
    % mysql-query DBNAME "QUERY..." --format csv

    # show as CSV table using Text::Table::CSV
    % FORMAT_PRETTY_T

). Or, you can output as JSON.

Examples:

 # by default, show as pretty text table, like in interactive mysql client
 % mysql-query DBNAME "SELECT * FROM t1"
 
 # show as JSON (array of hashes)
 % my