MySQL“全部"声明在phpmyadmin中不起作用 [英] MySQL "ALL" statement not working in phpmyadmin

问题描述

尝试在phpmyadmin ver中使用ALL语句时遇到一些问题. 4.5.4.1(最新).

I am having some issues when trying to use the ALL statement in phpmyadmin ver. 4.5.4.1 (latest).

当我用ANY替换ALL时，ANY语句似乎没有引起任何问题，并且使用ALL的所有子查询实际上都起作用.这是一个示例示例:

The ANY statement doesn't seem to cause any issue and all subqueries that make use of ALL actually work when I replace the ALL with an ANY. Here's a sample example:

 SELECT * FROM T
 WHERE A >= ALL (
 SELECT T2.A FROM T T2)

此查询引发以下两个错误消息:

This query trows the following two error messages:

Unrecognized keyword. (near "ALL" at position 50)
Unexpected token. (near "(" at position 54)

当我用ANY切换ALL(但不能给出正确的结果)时，它完美地工作了.

And it perfectly works when I switch the ALL with an ANY (but doesn't give the right result).

有任何已知的解决方法吗?从phpmyadmin的角度来看这是一个问题吗?谢谢您的宝贵时间.

Is there any known fix? Is it an issue from phpmyadmin's side? Thanks for your time.

推荐答案

在我看来，这是phpMyAdmin解析器库的问题；我已经在 https://github.com/phpmyadmin/phpmyadmin/issues/12028

This appears to me to be a problem with the phpMyAdmin parser library; I've reported it at https://github.com/phpmyadmin/phpmyadmin/issues/12028

这篇关于MySQL“全部"声明在phpmyadmin中不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！