Rename columns in MySQL / MariaDB

There are two ways to syntax to rename column in MariaDB database. You should use the the one that your engine support based on version of your database. The version of the engine will be prompted during cli login to MySQL/ MariaDB.

— (MariaDB before < 10.5.2 );

-- (MariaDB before 10.5.2 );
ALTER TABLE t1 CHANGE COLUMN title t CHAR(2); 

— (MYSQL 8.0 and MariaDB 10.5.2);

-- (MYSQL 8.0 and MariaDB 10.5.2);
ALTER TABLE t1 RENAME COLUMN title TO t; 

src: https://mariadb.com/kb/en/alter-table/#rename-column
src: https://dev.mysql.com/doc/refman/8.0/en/alter-table.html