开发者

Mysql not giving Syntax error when it should

开发者 https://www.devze.com 2023-03-15 21:30 出处:网络
I am trying with following query SELECT COU开发者_如何学编程NT(*) FROM users` WHERE email = \'xyz@xyz.com\'

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

精彩评论

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