MySql "NOT IN" clause not recognized in phpMyAdmin 4.5.0.2 -


a simple sql statement such as

select 1 mytable 1 not in (2); 

generates:

4 errors found during analysis.      1. unrecognized keyword (near "not in" @ position 30)     2. unexpected token. (near "(" @ position 37)     3. unexpected token. (near "2" @ position 38)     4. unexpected token. (near ")" @ position 39) 

i noticed on phpmyadmin website "current version compatible php 5.5 7.0 , mysql 5.5". version of mysql using 5.6.26. problem? above sql des not cause problem when entered directly via mysql.exe (mysql console).

fixed upcoming phpmyadmin 4.5.1.


Comments