不对啊，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
