When I did not put the backticks on the table name, it did not select the table.
SELECT * FROM `member` WHERE email = ?
Asked
Active
Viewed 161 times
0
-
1Are you running MySQL 8.0.17 or 8.0.18? – Nick Mar 22 '20 at 05:35
-
I'm running MySQL 8.0.18 – Abnormal Dev Mar 22 '20 at 05:55
-
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
1 Answers
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
haron68
- 741
- 1
- 5
- 19