Mysql not giving Syntax error when it should

Question

I am trying with following query

SELECT COUNT(*) 
  FROM users` 
  WHERE email = 'xyz@xyz.com'

This is not giving me syntax error (notice not include ` character at the starting of table name). And always gives me count as 1, although record in not there in db.

I will get the error if i remove COUNT from the query.

Hope this is not a bug in mysql.

what are you trying to query for? this query just counts the number of users with a specific email. — aporat, Jun 27 '11 at 14:29
It seems to behave like the backtick is commenting out the rest of the line... — Brendan Bullen, Jun 27 '11 at 14:32
@Brendan Bullen you are right the query after backtick is not executing would have accepted if it was an answer — jimy, Jun 27 '11 at 14:36
I wonder if the backtick is causing " WHERE email = 'xyz@xyz.com' " to be treated as an alias to the table users. — Jaydee, Jun 27 '11 at 14:58
interesting enough, if you put the backtick in front of users, it thinks everything after it is the table name (and says unknown table users where email =... — Maxim Krizhanovsky, Jun 27 '11 at 15:19

score 2 · Accepted Answer · answered Jun 27 '11 at 14:53

2

The backtick seems to be commenting out the rest of the line.

I can't say why but I have tested it (through phpMyAdmin) and that it the case.

answered Jun 27 '11 at 14:53

Brendan Bullen

11,607
1
31
40

Mysql not giving Syntax error when it should

1 Answers1