Home >Database >Mysql Tutorial >MYSQL必知必会读书笔记第六章之过滤数据_MySQL
MYSQL必知必会读书笔记第六章之过滤数据_MySQL
- WBOYOriginal
- 2016-05-27 13:44:391177browse
代码如下:
SELECT vend_id FROM products where vend_id 1003
等同于
代码如下:
SELECT vend_id FROM products where vend_id ！=1003
代码如下:
SELECT prod_name，prod_price FROM products WHERE prod_price BETWEEN 5 AND 10;
代码如下:
select * from products
where prod_price is Null;
以上所述是小编给大家分享的MYSQL必知必会读书笔记第六章之过滤数据的相关内容，希望对大家有所帮助！
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：MySQL中使用SQL语句对字段进行重命名_MySQLNext article：MySQL下载安装、配置与使用教程详细版（win7x64）_MySQL