view release on metacpan or  search on metacpan

bin/db-browser  view on Meta::CPAN

=over

=item

for the table name

=item

if the first data row should be used as a header

Selecting the prompt line of this menu allows you to set the 'create table' options.

=item

if an auto increment column should be added (if the option is enabled in L</Create-Table>)

=item

to edit the column names

=item

to edit the column data types

=item

to confirm the creation of the table

=back

=head3 Drop Table

Dropping a table displays the entire table before confirming the deletion.

=head3 Create View

Before creating a view, print the required select statement to make it available in the subquery menu.

=head3 Drop View

Drop a view. The entire view is shown before the user confirms dropping it.

=head2 Insert/Update/Delete

I<Insert>, I<Update> and I<Delete> can be accessed by selecting the prompt-line in the L</SQL Menu> if the respective
option is activated.

I<Delete>, I<Update>, or I<Insert> may not be available with C<Join> and C<Union>/C<Intersect>/C<Except> statements.

=head3 Insert

If the option I<Source Type> is set to I<menu>, selecting I<Insert> opens a submenu where one can choose the type of
the data source. If I<Source Type> is set to I<plain> or I<file>, the set data source type is used without showing a
menu. For more information, see L</Data Input>.

If the first column of a table is an auto-increment column, the C<INSERT INTO> statement is built without this first
column. This feature is available if supported by the database plugin.

=head3 Update

Update records. The affected (and not yet updated) records are shown before the user confirms the update.

=head3 Delete

Delete records. The affected records are shown before the user confirms the deletion.

=head2 Data Input

=head3 Data Source

=over

=item plain

Insert the data cell by cell.

=item file

The data is read from a chosen file.

Supported file formats: text files and file formats supported by L<Spreadsheet::Read>. C<Spreadsheet::Read> uses
different parser modules for the different file formats - see L<Spreadsheet::Read/DESCRIPTION>. The parser modules are not
installed automatically. It is up to the user to install the required parser modules.

Selecting I<file> opens the I<Source directory> submenu where one can choose the directory which should be
searched for files.

If the L</Directory History> is set to C<1>, the I<Source directory> submenu is skipped and the directory is chosen
automatically.

After a directory has been chosen, a submenu is opened where one can choose the source file.

Selecting the prompt line of the I<Files> submenu (I<Choose a File:>) allows one to set the parse settings described in
L</Import Data>.

After the data has been read, the user can apply different input filters (See L</Input Filters>).

=back

=head3 Input Filters

=over

=item Choose Cols

Use only selected columns of the imported data.

If a column is completely empty, the header is temporarily named C<-->.   If a column has no header name but contains
data, the header is temporarily named C<tmp>.

=item Choose Rows

Use only selected rows of the imported data.

=item Range Rows

Use only ranges of rows.

=item Row Groups

If the input has rows with different numbers of columns, I<Row Groups> sorts rows with the same number of columns into a