查询响应，请参见《参考手册》中的“函数名称解析和解析"部分 [英] Query Responds With Check the 'Function Name Parsing and Resolution' section in the Reference Manual

问题描述

有人可以告诉我这是怎么回事吗?

SELECT COUNT (`ID`) FROM `tableImSpecifying` WHERE `VisitorsEmail` = '$VarThatHoldsEmailFromA$_POSTInput'

这是我在学习教程时编写的程序的一部分，但是我对如何解决此问题挂了电话.我将非常感激，如果有人可以告诉我如何解决此问题，我先谢谢您.

这是我看到的错误:

功能myhost_classifieds.COUNT不存在.检查参考手册中的函数名称解析和解析"部分

让我感到困惑的是，在该查询上方我有类似的查询可以正常工作，并且我已经检查了&的语法.结束了，但我看不出有什么问题.

解决方案

此:

功能myhost_classifieds.COUNT不存在.检查参考手册中的函数名称解析和解析"部分

会提示您阅读此内容

哪个会导致您对此进行更改:

COUNT (`ID`)

收件人:

COUNT(`ID`)

(请注意已删除的空间).

(您还可以在 IGNORE_SPACE ，但我不建议新手使用.

Would someone please explain to me what is wrong with this??

SELECT COUNT (`ID`) FROM `tableImSpecifying` WHERE `VisitorsEmail` = '$VarThatHoldsEmailFromA$_POSTInput'

This is part of a program I am writing while following a tutorial but I'm hung up on how to fix this. I'd be most appreciative and I thank you in advance if anyone can tell me how to fix this.

Here's the error I'm seeing:

FUNCTION myhost_classifieds.COUNT does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual

What baffles me is I have similar queries above this one that work properly and I've checked the syntax over & over but I don't see what's wrong.

解决方案

This:

FUNCTION myhost_classifieds.COUNT does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual

Would prompt you to read this

Which leads you to alter this:

COUNT (`ID`)

To:

COUNT(`ID`)

(note the removed space).

(you could also fiddle around with IGNORE_SPACE, but I wouldn't recommend it for a novice.

这篇关于查询响应，请参见《参考手册》中的“函数名称解析和解析"部分的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！