distal-attribute
distal-attribute
distal-attribute
distal-attribute

Can I use periods "." in field names?

User, date Message
Written by Dr. DaveMoney, Euro
6 years ago
Category: General
105 posts since Sun, 27 Jan 08
I hope it's okay to post this question here, as it doesn't particularly relate to HeidiSQL.

I'd like to create a field in one of my tables. Instead of using an underscore "_" to separate 2 words, like "first_name", I want to use a period, like "first.name"

Is this legal?

(no, I'm not interested in using "firstName" or "first_name", unless I absolutely have to)


:)

Thanks in advance.
Written by kalvaro
6 years ago
595 posts since Thu, 29 Nov 07
According to documentation the dot character is allowed in field names:

http://dev.mysql.com/doc/refman/5.0/en/identifiers.html

I suppose you'll have to quote it every time:

SELECT `first.name`FROM users

If it's a good idea or not, I leave it to you ;-)
Written by Dr. DaveMoney, Euro
6 years ago
105 posts since Sun, 27 Jan 08
Thank you, you're absolutely correct.

I found this:
Before MySQL 5.1.6, database and table names cannot contain
 

Please login to leave a reply, or register at first.