Is it ok to mention a table name in lower case while creation and in uppercase while retrieving data from MySQL DB?

MySQL is a case sensitive platform. We have to specify the object names in same case all the times. Generally on all the Unix based platforms MySQL enforces case-sensitive rule for object names. In Microsoft Windows based installation MySQL does not enforce case-sensitive rule.

So it is always safe to use same case for Object names in CREATE and SELECT queries.

We can also use system level parameter lower_case_table_names to set the correct option for case-sensitivity in MySQL.