2

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?

1
  • 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.
    – user1822
    Feb 10, 2015 at 15:52

1 Answer 1

3

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.

1
  • Case #3: When you use an ORM based application (which uses camel/pascal case usually) and every time you migrate & generate code using the database schema, you need to convert every field name from snake_case to Camel/Pascal case (hundreds of fields), kind of breaks the point of ORMs.
    – mixdev
    Nov 2, 2022 at 7:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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