SQL 计数 - 不工作

发布于 2024-12-10 22:25:52 字数 323 浏览 0 评论 0原文

我正在尝试此代码：

SELECT COUNT (oferta_id_oferta) 
FROM `oferta_has_tags` 
WHERE oferta_id_oferta = 
(SELECT id_oferta FROM oferta 
WHERE oferta = "designer")

我收到错误：1630 - FUNCTION mydb.COUNT 不存在。检查参考手册中的“函数名称解析和解析”部分

如果删除 COUNT 单词，我会得到两个结果。

问题是什么？

原文

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?

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

风透绣罗衣 2024-12-17 22:25:52

不要放置空格

SELECT COUNT(oferta_id_oferta) 
FROM `oferta_has_tags` 
WHERE oferta_id_oferta = 
(SELECT id_oferta FROM oferta 
WHERE oferta = "designer")

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")

回复收藏 0 原文

浮生未歇 2024-12-17 22:25:52

尝试删除 COUNT 和括号之间的空格：

SELECT COUNT(oferta_id_oferta) 
FROM `oferta_has_tags` 
WHERE oferta_id_oferta = 
(SELECT id_oferta FROM oferta 
WHERE oferta = "designer")

此外，您可以通过加入来删除子查询：

SELECT COUNT(oferta_id_oferta) 
FROM `oferta_has_tags`, `oferta`
WHERE
    oferta_has_tags.oferta_id_oferta = oferta.id_oferta
    AND oferta.oferta = "designer"

Try removing the space between COUNT and the parentheses:

SELECT COUNT(oferta_id_oferta) 
FROM `oferta_has_tags` 
WHERE oferta_id_oferta = 
(SELECT id_oferta FROM oferta 
WHERE oferta = "designer")

Also, you can probably get rid of your subquery by joining:

SELECT COUNT(oferta_id_oferta) 
FROM `oferta_has_tags`, `oferta`
WHERE
    oferta_has_tags.oferta_id_oferta = oferta.id_oferta
    AND oferta.oferta = "designer"

回复收藏 0 原文

~没有更多了~