mariadb change column data type code example

Example 1: mariadb alter table add column if not exists example

ALTER TABLE tableName ADD COLUMN IF NOT EXISTS colName INT;

Example 2: mariadb change column type

ALTER TABLE Schema.TableName
  CHANGE COLUMN CurrentTableName NewTableName MEDIUMTEXT DEFAULT NULL COMMENT '(DC2Type:json_array)';