SQL计数 - 不工作 [英] SQL count - not working
本文介绍了SQL计数 - 不工作的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我在尝试此代码:
SELECT COUNT(oferta_id_oferta)
从`oferta_has_tags`
WHERE oferta_id_oferta =
(SELECT id_oferta FROM fromerta
WHERE oferta =designer)
我收到错误:1630 - FUNCTION mydb.COUNT不存在。检查参考手册中的函数名解析和解析部分
如果我删除 COUNT $
解决方案 / div>
不要放空格
SELECT COUNT(oferta_id_oferta)
FROM`oferta_has_tags`
WHERE oferta_id_oferta =
(SELECT id_oferta FROM oferta
WHERE oferta =designer)
I am trying this code:
SELECT COUNT (oferta_id_oferta)
FROM `oferta_has_tags`
WHERE oferta_id_oferta =
(SELECT id_oferta FROM oferta
WHERE oferta = "designer")
I receive error: 1630 - FUNCTION mydb.COUNT does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual
If I remove the COUNT
word, I get two results.
What is the problem?
解决方案
Don't put a space
SELECT COUNT(oferta_id_oferta)
FROM `oferta_has_tags`
WHERE oferta_id_oferta =
(SELECT id_oferta FROM oferta
WHERE oferta = "designer")
这篇关于SQL计数 - 不工作的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文