mysql - 如何检查表中多列是否为空

Question

我正在尝试创建一个进度条来检查用户是否已填写数据库中的数据。

到目前为止我已经做到了这一点，但是有没有更短的方法来做到这一点？此外，我在 MYSQL 工作台上收到一条警告消息:

"Select is not valid at this position for this server version, expecting: '(',with

SELECT * FROM userCertificate 
WHERE certificatename IS NOT NULL 
AND organization IS NOT NULL 
AND location IS NOT NULL 
AND startdate IS NOT NULL;

Answer 1

您可以对多列使用 COALESCE 函数

SELECT *
FROM userCertificate
 WHERE 
coalesce(certificatename, organization, location, startdate) 
IS NOT NULL;