coalesce definition in Cambridge Dictionary:
- If two or more things coalesce, they come or grow together to form one thing or system.
- to combine into a single group or thing
But in MySQL, coalesce means:
COALESCE(): Return the first non-NULL argument
As an ESL(English as Second Language), That confused me a lot. From the meaning in the dictionary, coalesce is a synonym to combine or merge.
What I expect when I read coalesce, is:
COALESCE(): Concatenate all arguments
but it isn't.
Could anyone please explain that for me?