add column mariadb code example

Example 1: mariadb rename field

ALTER TABLE table_name
  CHANGE COLUMN old_name new_name 
    column_definition
    [ FIRST | AFTER column_name ]

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

ALTER TABLE tableName ADD COLUMN IF NOT EXISTS colName INT;