softlab Posted January 29, 2018 Share Posted January 29, 2018 Hi. I wrote some SQL statements, referencing table names in uppercase. When my java code tries to execute them, an error is send, telling that table name does not exist. I also saw that in phpMyAdmin table names are in lowercase. Is there a way to reference them in uppercase (or in a not case sensible way)? Thanks Quote Link to comment Share on other sites More sharing options...
Krydos Posted January 29, 2018 Share Posted January 29, 2018 Mysql itself isn't case sensitive. Windows is not case sensitive so mysql on windows isn't case sensitive. Linux is case sensitive so mysql on linux is case sensitive. A table named TEST is different from test on linux. I just always do everything in lowercase to make it consistent. Mysql has a hard enough time without me yelling at it in all caps. Quote Link to comment Share on other sites More sharing options...
softlab Posted January 29, 2018 Author Share Posted January 29, 2018 Ok, thanks. I renamed all the tables in uppercase and now it's ok. Quote Link to comment Share on other sites More sharing options...
Krydos Posted January 29, 2018 Share Posted January 29, 2018 "Stop yelling at me!", mysql probably. Quote Link to comment Share on other sites More sharing options...
michaeltim Posted February 8, 2018 Share Posted February 8, 2018 I strongly recommend to always use lowercase names. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.