First of all, making a column or table name case sensitive will cause additional work in data management. You need to consider if you really want the names to be case sensitive. Case sensitive also means the name can contain special characters like space. In general, this is not a best practices. However, if you really need to do this, the following is an example:
mysql> alter table TCUSTMER add column `region code` varchar(30) after name; Query OK, 4 rows affected (0.06 sec) Records: 4 Duplicates: 0 Warnings: 0 mysql> desc TCUSTMER; +-------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+-------+ | CUST_CODE | varchar(4) | NO | PRI | NULL | | | NAME | varchar(30) | YES | | NULL | | | region code | varchar(30) | YES | | NULL | | | CITY | varchar(20) | YES | | NULL | | | STATE | char(2) | YES | | NULL | | +-------------+-------------+------+-----+---------+-------+ 5 rows in set (0.00 sec)
Note that we use back quote to include the qualified name. The back quote on the keyboard is highlighted in the following figure.