None of the fields that are part of the primary key can contain a null value. Note: Be careful when shortening the field length as losing data might be caused.Ĭheck this box to not allow the NULL values for the field.Ĭheck this box to enable the virtual column settings for the field.Ī Primary Key is a single field or combination of fields that uniquely defines a record. Use the Length edit box to define the length of the field and use Decimals edit box to define the number of digits after the decimal point (the scale) for Floating Point data type.
See MySQL Data Types/ MariaDB Data Types for details. The Type drop-down list defines the type of the field data. Note that the name of the field must be unique among all the field names in the table. Use the Name edit box to set the field name. To add a new field with modification as one of the existing fields, you can right-click and select the Duplicate Field from the pop-up menu.
0 kommentar(er)
