mysql-native v3.0.0

API Reference Home: [This Version] [Latest Version] [Other Versions]

Variable ColumnInfo.defaultNull

Is the COLUMN_DEFAULT column (in the information schema's COLUMNS table) NULL?

struct ColumnInfo
{
  // ...
  bool defaultNull ;
  // ...
}

What this means:

On MariaDB 10.2.7 and up: - Does the column have a default value?

On MySQL and MariaDB 10.2.6 and below: - This can be true if the column doesn't have a default value OR if NULL is the column's default value.

See also

See COLUMN_DEFAULT description at https://mariadb.com/kb/en/library/information-schema-columns-table/