Case senstive database/schema name
Posted by:
John Dunn
Date: August 23, 2017 05:16AM
I am running software that runs all sql in uppercase. The SQL select statement is failing because the database name is in lowercase (mydb).
e.g SELECT (*) FROM MYDB.MYTABLE;
SELECT command denied to user 'MYUSER'@'localhost' for table 'MYTABLE'
Works OK if query on mydb.MYTABLE
Is there a SIMPLE way to resolve this in MySQL?
Version is 5.5
Subject
Written By
Posted
Case senstive database/schema name
August 23, 2017 05:16AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.