Friday, 6 October 2017

Windows MySQL case sensitive

I have a problem. I'm using Windows at work to develop but the server is Linux. I often work with database queries.



Now, I often type the table name in wrong caps (like, in lowercase if first 3 characters are uppercase). How can I turn case sensitivity on Windows on?



I currently have tried putting



lower_case_table_names=1


After




interactive-timeout


And I've also tried putting



lower_case_table_names=0


After




interactive-timeout


None of them work though and my script still works fine on Windows where it would bug in Linux.

No comments:

Post a Comment

casting - Why wasn't Tobey Maguire in The Amazing Spider-Man? - Movies & TV

In the Spider-Man franchise, Tobey Maguire is an outstanding performer as a Spider-Man and also reprised his role in the sequels Spider-Man...