代码如下:
<br />SELECT vend_id FROM products where vend_id 1003<br />
等同于
<br />SELECT vend_id FROM products where vend_id !=1003<br />
代码如下:
<br />SELECT prod_name,prod_price FROM produc<strong style="color:transparent">来2源gaodaima#com搞(代@码&网</strong>ts WHERE prod_price BETWEEN 5 AND 10;<br />
代码如下:
<br />select * from products<br />where prod_price is Null;<br />
以上所述是小编给大家分享的MYSQL必知必会读书笔记第六章之过滤数据的相关内容,希望对大家有所帮助!