year as a Column Name in a MySQL Table

Question

Hi,

I've got an easy question. Is it okay to name a column in a mysql table 'year'? Any reason not to?

Thanks,

-Laxmidi

Answer 1

You can name it year, there is no reason not to do so because it is not the reserved keyword of mysql/sql.

Answer 2

Check the MySQL Keywords list if you're ever curious.

Answer 3

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

Answer 4

If you quote your identifiers properly, you can use almost any word you want:

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