I have a database where column names are all camel cased. No problems encountered. Will that be a problem under some scenarios, as per recent versions of MySQL, Postgres?

  • 2
    It depends: select ThisIsAColumnName from SomeTable is the same as select thisisacolumnanme from sometable (according to the SQL standard) . This is true for all Postgres versions. On MySQL this depends the storage engine used, the MySQL and storage engine configuration and the file system that is used. I personally prefer snake_case over CamelCase in SQL - but that is just my opinion. – a_horse_with_no_name Feb 10 '15 at 15:52

The only cases I can think of for MySQL where case sensitivity could be an issue would be

In those cases, the table name can cause problems. As for column names, it should not be an issue.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.