What naming conventions in database creation, tables, and columns in mysql

Navigation
2

I would like to know what kind of conventions exist in database names, tables and columns in mysql , is it usually used camelCase or other type of convention?

    
asked by anonymous 17.02.2014 / 11:14

1 answer

4

MySQL is not Case Sensitive in Windows, so regardless of the "case" of creating the table, you can always access it by table1 or TABLE1, as is the case with columns.

What does not happen with Linux, which is Case Sensitive.

Although it is configurable (see as in: link )

What I suggest is to use nomenclature that is platform independent (Windows or Linux) and MySQL configuration:

Table Names:

SALES REQUEST

PRIVATE_PROFIT

CLIENTS_ENDERECOS

And for columns:

REQUEST_ID, NUM_ENDERECO, VALUE_UNITARY

    
17.02.2014 / 12:09
How to load all the functions of a folder? Problem with date Laravel