"year" as a column name in a MySQL table

Question

Can I name a column in a MySQL table year

? Any reason not for?

+2

Laxmidi Apr 22 10 at 22:53

5 answers

If you spell your IDs correctly , you can use almost any word you want:

SELECT * FROM `select` WHERE `select`.id > 100;

+4

nickf Apr 22 10 at 11:14 pm

Check out the MySQL keyword list if you're ever curious.

+1

statenjason Apr 22 10 at 22:56

It's not one of the reserved words , so it should be good.

0

Dominic Barnes Apr 22 10 at 22:56

Please note that as of version 5.5 YEAR there is a reserved keyword.

I also think that in this case, statenjason will answer, "Check the MySQL keyword list if you're ever curious." must be correct.

0

Josafat 05 jan. 17 at 23:25

Sarfraz · Accepted Answer · 2010-04-22T22:55:31+0000

You can name it year

, there is no reason not to because it is not a mysql / sql reserved keyword .