Wednesday, 4 May 2016

mysql : make mysql db to be case sensitive for queries

In my mysql db, i have a table called customer



In my local test environment mysql db, I can do select * from Customer but when my code is rolled out to a production environment for clients to use, select * from customer throws syntax error.




This is because the production environment mysql db is case sensitive.



How do i change my local enviorement mysql to be case sensitive?



Thanks!

No comments:

Post a Comment

c++ - Does curly brackets matter for empty constructor?

Those brackets declare an empty, inline constructor. In that case, with them, the constructor does exist, it merely does nothing more than t...