Add/Edit field

When you import data with destination table creation, you can manage this table's fields.

Use the context menu to New/Edit/Drop a colimn.

Selecting New column or Edit column context menu item opens the field editor that allows you to view/edit the properties of the destination table fields.

Use the Column edit box to set the field name. Note that the name of the field must be unique among all the field names in the table.

The Type tab defines the type of the field data.

Size

Defines the size of the field value.

Scale

For numeric and decimal types you need to define the number of decimal to the right of the decimal point.

Default value

Define this option value if you need inserted records to get specified value.

Values

At this field you can define ENUM and SET field's values.

Not NULL

Check this option to prevent the entry of NULL or unknown values in column.

Autoincrement

Enable this option to generate field values automatically.

Use dimension

Enable the option to set the dimension properties for field types having dimension properties (e.g. integer, float, or timestamp data types).

Unsigned

Assigns the UNSIGNED attribute to the field: integer data will be displayed unsigned.

Zerofill

Assigns the ZEROFILL attribute to the field: for columns of the numeric data type, MySQL will automatically add zeros before the first significant digit of the number stored in this column.

Primary key

Check this option to include the field into the primary key. Note that if you include a field to a primary key, you should also make it Not Null.

A table typically has a column or combination of columns that contain values that uniquely identify each row in the table. This column, or columns, is called the primary key (PK) of the table and enforces integrity of the table.