view release on metacpan or  search on metacpan

bin/db-browser  view on Meta::CPAN

     Year | 2000 | 2001 | 2002              Year | Max | Min
    ------|------|------|------             -----|-----|----
     Max  |   14 |   22 |   17              2000 |  14 |  11
    ------|------|------|------             -----|-----|----
     Min  |   11 |   10 |    9              2001 |  22 |  10
                                            -----|-----|----
                                            2002 |  17 |   9

=item Empty to NULL

Convert fields containing an empty string to NULL (undefined).

The default values for this filter can be set using the option L</Empty to Null>.

=item Reset

Reset the filters.

=item Reparse

Change the parse settings and reparse the data with the new settings.

=back

=head1 GLOABL SETTINGS

=head2 Select plugins

Choose the required database plugins.

=head2 Gloabl settings

=head3 Menu Memory

If enabled, saves the menu position while entering a submenu.

=head3 Mouse Mode

Set the I<Mouse mode> (see L<Term::Choose/mouse>).

=head1 OPTIONS

The options menu is accessed with C<db-browser -h>.

Select the database plugin and then configure the following options.

=head2 Connect data

By selecting the prompt line of the plugin settings menu (Configure plugin-name), you can set the connect data at
database level.

=over

=item Fields

Set which fields are required to connect to a database.

=item Login Data

The entered login data is saved in a configuration file and used to connect to the database (the password cannot be
saved).

=item ENV Variables

The user can choose environment variables from a list of environment variables that should be used - if set - to connect
to the database.

=item Attributes

For the meaning of these driver-specific attributes, refer to the appropriate driver documentation.

=back

=head2 Extensions

Add menu entries to menus:

=head3 Tables Menu

=over

=item Subquery

=item CTE

=item Join

=item Union

=back

=head3 Join Menu

=over

=item Subquery

=item CTE

=back

=head3 Union Menu

=over

=item Subquery

=item CTE

=item Where

=item Parentheses

=back

Note: Parentheses are not available in C<SQLite> and C<Firebird>.

These settings are also valid when C<Intersect> or C<Except> is used.

=head3 Columns and Values