Creating Database Records

Automate database record creation with the Database Book.

To create a new database record, use the following procedure:

Syntax

create a {table} in database with
  {field} is {value}

Components

• table - The name of the database table where the new record will be added.

• field - A specific field in the table (e.g., LastName, FirstName).

• value - The data you want to store in that field.

Example

create a person in database with
  the LastName is "Smith"
  the FirstName is "John"
  the Address is "123 Apple St"
  the DOB is "1980-04-03"

In this example, person is the name of the database table. A new record is created in that table with the information provided after with. Each indented line represents a column (LastName, FirstName, etc.) and its corresponding value.