Why do I need to put the backticks on the table name `member` in order to select the table?

Question

When I did not put the backticks on the table name, it did not select the table.

SELECT * FROM `member` WHERE email = ?

In those two versions `member` is a reserved word, and has to be enclosed in backticks when used as an identifier. — Nick, Mar 22 '20 at 05:56

score 0 · Answer 1 · answered Mar 22 '20 at 05:44

0

Because in some SQL syntax member or MEMBER is a reserved keyword. In order to distinguish your table name with member you need to use backticks.

`member` (instead of) member

https://docs.microsoft.com/en-us/sql/t-sql/language-elements/reserved-keywords-transact-sql?view=sql-server-ver15

answered Mar 22 '20 at 05:44

haron68

731
1
4
18

Oh I see. Thank for that! – Nam Mar 22 '20 at 05:55
@Nam Would appreciate an upvote or acceptance if this helped you :) – haron68 Apr 15 '20 at 22:36

Why do I need to put the backticks on the table name `member` in order to select the table?

1 Answers1