Is MySQL Case-Sensitive?
The SQL syntax is NOT case-sensitive in MySQL.
If the application written in PHP/Perl or other languages were to be used in Microsoft & Linux environment, then it would really be an issue for the database administrators and for the programmers.
That is the reason why you might have noticed books or sites saying that it is always recommended to treat MySQL syntax as being case-sensitive.
It was interesting to learn that the database name remains case sensitive.