1

Could someone tell me if it's alright to use capital letters in column titles in Mysql?

Sorry if this a dumb question, but i just couldn't find the answer anywhere else...

Thanks

something
  • 517
  • 3
  • 10
  • 22
  • 2
    If you had spent the 2 minutes you spent on your question on trying to create a new table with capital letters, you'd have had your answer sooner. – kba Dec 22 '11 at 16:43
  • @kba It's a valid question, and for everyone else who may or may not have a database they can test with, it's faster and more trustworthy to have an upvoted answer to the question than to try it out themselves, and potentially make mistakes. – user985366 Aug 04 '16 at 11:17

1 Answers1

6

See the MySQL documentation:

Schema Object Names

and

Identifier Case Sensitivity

You can use upper case but names are case-insensitive on all platforms. You should not use two different cases for the same object within the same statement, though.

D'Arcy Rittich
  • 167,292
  • 40
  • 290
  • 283