Imports file into a database

Synopsis

• dbimport file database ?-option value -option value ..?

Description

This command takes the contents of the file file in the current directory and stores it in the database database. If the file was produced by the dbdump command, no further information is needed to process it. If not, you will need to set several options, described below, to import the data correctly.

-datafile

When this option is present, dbimport gets the information from a data file, rather than a file in the current directory.

-fields list

The list of field names for each record. This option is required if the file is not from a dbdump.

-seperator char

The seperator character between each field in a record. The default character is a comma (,).

-key fieldname

The name of the field that has the key for the record to be stored by. If this option is omitted, or its value is set to numbers, the key for each record will be its line number in the file.