不對啊，not in 和！=all 的結果不一樣的
mysql> SELECT good_id,goods_name,goods_price FROM tdb_goods WHERE goods_price!=ANY(select goods_price FROM tdb_goods where goods_cate='超級本');
26 rows in set
mysql> SELECT good_id,goods_name,goods_price FROM tdb_goods WHERE goods_price NOT IN
(select goods_price FROM tdb_goods where goods_cate='超級本');
23 rows in set
mysql> SELECT good_id,goods_name,goods_price FROM tdb_goods WHERE goods_price <>ALL
(select goods_price FROM tdb_goods where goods_cate='超級本');
23 rows in set
2016-09-27
你的第一行代碼使用的是 !=ANY，而不是 !=ALL......
2017-06-15
你這。。。。