开发者

Mysql not giving Syntax error when it should

I am trying with following query

SELECT COU开发者_如何学编程NT(*) 
  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.


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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜