Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > mysql中将null值转换为0的语句

mysql中将null值转换为0的语句

WBOY
Release： 2016-06-07 18:03:23
Original
1744 people have browsed it

mysql中将null值转换为0的语句，在mysql数据库开发中，如果后期添加了字段那么这些值为空值null，我们在使用者需要将null转换为0方便后期的控制就需要下面的代码了。

代码如下:
SELECT
IF(AVG(cai.conversionsRate) IS NULL,0,AVG(cai.conversionsRate))
AS conversionsRate
FROM campaign_info cai
WHERE insertTime BETWEEN '2011-02-01' AND '2011-02-04' AND googleCampaignId=23331401

Related labels：
null
source：php.cn
Previous article：MySQL数据库管理常用命令小结 Next article：navicat 8 创建数据库与创建用户分配权限图文方法
Statement of this Website
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
Latest Articles by Author
Latest Issues
In React, localstorage.getItem returns null index.js：importReactfrom'react';importReactDOMfrom'react-dom/client';import'./index.css';i...
From 2024-04-05 14:18:19
0
1
1523
POST request works fine when using Postman but not when using React axios and Spring Boot backend From the react console I get the error "Unable to load resource: Server response stat...
From 2024-04-05 13:07:01
0
1
396
How to retrieve values ​​of unselected rows in HTML data table using jquery I'm trying to get the value of all rows where the button was not clicked. For example, whe...
From 2024-04-05 09:26:49
0
1
1418
Forced refresh is a consequence of accessing undefined paths or error pages in Next.js Accessing an undefined path or error page causes Next.js to do a hard refresh, causing my ...
From 2024-04-05 08:32:46
0
1
400
MySQL: Find columns matching integers in a text (CSV) column This table has a text column that stores references to other records in CSV format, for ex...
From 2024-04-04 18:03:46
0
1
291
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template