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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With