Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

MySql "NOT IN" clause not recognized in phpMyAdmin 4.5.0.2

Tags:

phpmyadmin

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

like image 697
Booboo Avatar asked Oct 20 '25 06:10

Booboo


1 Answers

Fixed for the upcoming phpMyAdmin 4.5.1.

like image 80
Marc Delisle Avatar answered Oct 22 '25 03:10

Marc Delisle



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!