search

Home >Database >Mysql Tutorial >MySQL 的 IFNULL 查询

MySQL 的 IFNULL 查询

WBOY
WBOYOriginal
2016-06-07 14:54:591182browse

如果 f1 为空 就是用 f2 ，这就是 IFNULL MySQL SELECT * FROM 用户表 ORDER BY IFNULL(nickname, realname);SELECT IFNULL(NULL,10); -- 10

如果 f1 为空 就是用 f2 ，这就是 IFNULL
MySQL 
SELECT * FROM 用户表 ORDER BY IFNULL(nickname, realname);

SELECT IFNULL(NULL,10); -- > 10
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：SQL分页存储过程Next article：pl/sql对采用数字格式的日期进行日期的转换

Related articles

See more