页次: 1
首先创建一个表
http://www.ipbbs.net/viewtopic.php?id=165
mysql> select * from goods where g_id > any (select 4); +------+--------+------+---------+ | g_id | g_name | v_id | g_price | +------+--------+------+---------+ | 5 | bbb | 2 | 5.10 | | 6 | bbb | 3 | 6.10 | | 7 | ccc | 1 | 7.10 | | 8 | ccc | 2 | 8.10 | | 9 | ccc | 3 | 9.10 | +------+--------+------+---------+ 5 rows in set (0.00 sec)
mysql> select * from goods where g_id > any (select g_id from goods) ; +------+--------+------+---------+ | g_id | g_name | v_id | g_price | +------+--------+------+---------+ | 2 | aaa | 2 | 2.10 | | 3 | aaa | 3 | 3.10 | | 4 | bbb | 1 | 4.10 | | 5 | bbb | 2 | 5.10 | | 6 | bbb | 3 | 6.10 | | 7 | ccc | 1 | 7.10 | | 8 | ccc | 2 | 8.10 | | 9 | ccc | 3 | 9.10 | +------+--------+------+---------+ 8 rows in set (0.00 sec)
可以用 any, some, all, in , exists 比较运算等
ipbbs.net
离线
页次: 1