coalesce()可用于打印第一个NOT NULL列值。让我们首先创建一个表-create table DemoTable1927
(
StudentName varchar(20),
StudentSubject varchar(20)
);
使用插入命令在表中插入一些记录-insert into DemoTable1927 values('Chris','MySQL');
insert into DemoTable1927 values('David',NULL);
insert into DemoTable1927 values(NULL,'MongoDB');
使用select语句显示表中的所有记录-select * from DemoTable1927;
这将产生以下输出-+-------------+----------------+
| StudentName | StudentSubject |
+-------------+----------------+
| Chris | MySQL |
| David | NULL |
| NULL | MongoDB |
+-------------+----------------+
3 rows in set (0.00 sec)
这是在MySQL中实现Coalesce()的查询-select coalesce(StudentName,StudentSubject) as Result from DemoTable1927;
这将产生以下输出-+---------+
| Result |
+---------+
| Chris |
| David |
| MongoDB |
+---------+
3 rows in set (0.00 sec)