MariaDB (MySQL-compatible) Non-Spatial Writer: User Attributes

For information on the parameters in this dialog that are common to all readers, see:

For information on the parameters in this dialog that are common to all writers, see:

User attributes for this format are defined below.

Name

The name of the field to be written.

Valid values for field name include any character string devoid of SQL-offensive characters and less than 63 characters in length.

Type

The type of a column in a table. The valid values for the field type are listed below:

bigint

blob

char

date

datetime

decimal

double

double(width,decimal)

enum

float

float(width,decimal)

int

longblob

longtext

mediumblob

mediumint

mediumtext

set

smallint

text

time

timestamp

tinyblob

tinyint

tinytext

varchar

year

year(width)

Index

The type of index to create for the column. The valid values for the index type are listed below:

  • BTree: B-Tree-based geometry index (default attribute index)
  • Hash: Hash-based geometry index
  • PrimaryKey: Any primary key or identity attribute