ALTER TABLE; Change data type of column in existing table; MySQL phpMyadmin MariaDB; command line

MySQL Query to change the column's data type in a table without deleting or dropping or disturbing the existing table structure.
if any change in designing/structuring of the tables is needed without disturbing the existing tables; Use ALTER Command..
To change the data type of a column in a table, use the ALTER TABLE command.

Change datatype of column in MySQL,
How to change data type in SQL without dropping table,
SQL alter multiple columns,
Alter table SQL