Are there any good reasons why I shouldn't use - (dashes) in field names in MySQL?

Question

I have the name of the category_id field in the product table.

And also I want the category identifier name field to be the category id.

Are there any good reasons I shouldn't use in the field name?

Where can I find which character I should not use in the MySQL field and table name?

Answer 1

The main reason for using a hyphen is that most links must specify field names. Otherwise, they will look like a subtraction operator, both for MySQL and for people.

Answer 2

You can see a list of reserved words

, , , , backquotes.

Answer 3

The safest bet is to stick to the alphanumeric characters + _. This is pretty standard in terms of a “safe” name, since none of these characters can be distorted as operator characters.