My SQL Table Names are Case Sensitive in UNIX

I looked at case sensitivity in MySQL database names in a couple of earlier posts. Type case sensitivity in the SEARCH THIS BLOG box to the right and click on Search to see them if you are interested. I recently discovered that table names are case sensitive on UNIX too: 

mysql> create table andrew (col1 varchar(10));

Query OK, 0 rows affected (0.03 sec)

 

mysql> select * from andrew;

Empty set (0.00 sec)

 

mysql> select * from ANDREW;

ERROR 1146 (42S02): Table 'test.ANDREW' doesn't exist

mysql>