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?
Mysql – is camel case for column names safe
MySQLpostgresql
Related Question
- Postgresql – Columns names are case sensitive on postgres
- Postgresql – Two names for a column
- Mysql – How to JOIN a table with a name that equals to a determined value in MySQL
- PostgreSQL – Case-Insensitive Order While Preserving Case of Returned Strings
- PostgreSQL – Create Stored Procedure with Dynamic Number of Columns and Column Names
- PostgreSQL – Case Insensitive Column Names in Trigger Function
Best Answer
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.