question

Thameeraviraj avatar image
Thameeraviraj asked

Naming conventions - MySQL

Is there any naming conventions for MySQL DB, Tables and Columns? Can you guys please suggest me the right one?
mysqldatabase-namenamingnaming-convention
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
sqlaj 1 avatar image
sqlaj 1 answered
As far as I know MySQL does not have any naming convention restrictions. There are reserved words you can't use. > **MySQL Reserved Words** > http://dev.mysql.com/doc/refman/5.5/en/reserved-words.html Most of the time naming conventions fall under a standards document or policy established at your company. If you are trying to establish one then there are many, many different opinions on that process. Just do a little searching with your favorite search engine and see what you get. I would add though, what ever method you decide on, if that is what you are doing, is to be consistent across the board.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.