MySql的"NOT IN"子句在phpMyAdmin 4.5.0.2中无法识别 [英] MySql "NOT IN" clause not recognized in phpMyAdmin 4.5.0.2

问题描述

简单的SQL语句，例如

SELECT 1 from MyTable WHERE 1 NOT IN (2);

生成:

4 Errors were found during analysis.

    1. Unrecognized keyword (near "NOT IN" at position 30)
    2. Unexpected token. (near "(" at position 37)
    3. Unexpected token. (near "2" at position 38)
    4. Unexpected token. (near ")" at position 39)

我刚刚在phpMYAdmin网站上注意到当前版本与PHP 5.5到7.0和MySQL 5.5兼容".我正在使用的MySql版本是5.6.26.这可能是问题吗?通过mysql.exe(MySql Console)直接输入时，上述SQL某些问题不会引起问题.

解决方案

已修复即将推出的phpMyAdmin 4.5.1.

A simple SQL statement such as

SELECT 1 from MyTable WHERE 1 NOT IN (2);

generates:

4 Errors were found during analysis.

    1. Unrecognized keyword (near "NOT IN" at position 30)
    2. Unexpected token. (near "(" at position 37)
    3. Unexpected token. (near "2" at position 38)
    4. Unexpected token. (near ")" at position 39)

I just noticed on the phpMYAdmin website "Current version compatible with PHP 5.5 to 7.0 and MySQL 5.5". The version of MySql I am using is 5.6.26. Could this be the problem? The above SQL certain des not cause a problem when entered directly via mysql.exe (MySql Console).

解决方案

Fixed for the upcoming phpMyAdmin 4.5.1.

这篇关于MySql的"NOT IN"子句在phpMyAdmin 4.5.0.2中无法识别的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！