Case-Sensitive
First thing first, you need to check out with the available collations in the system.
ALTER TABLE enables you to change the structure of an existing table.
MySQL creates new columns for all elements in the SELECT.