[求解] XAMPP 环境，同样一句 SQL 语句，命令行下可执行，在 phpMyAdmin 里为什么就报错呢？

V2EX = way to explore

V2EX 是一个关于分享和探索的地方

For Existing Member Sign In

This topic created in 3781 days ago, the information mentioned may be changed or developed.

SQL 语句：
SELECT DISTINCT * FROM fsl AS f WHERE NOT EXISTS(SELECT * FROM usr WHERE usr.usrid = f.fsluid);

phpMyAdmin(v5.6.14)错误信息如下：
Unrecognized keyword. (near "NOT" at position 39)
Unrecognized keyword. (near "EXISTS" at position 43)
Unexpected token. (near "(" at position 49)

1 replies • 2015-12-24 10:51:21 +08:00

WayToGo

Dec 24, 2015

原来这是一条 BUG. :(
https://github.com/phpmyadmin/phpmyadmin/issues/11646