GROUP_CONCAT函数忽略拼接空字符串

GROUP_CONCAT函数在进行字符串拼接时，默认会忽略拼接的空字符串。也就是说，如果拼接的过程中出现了空字符串，那么这个空字符串将会被忽略，最终得到的结果中不会包含这个空字符串。这一特性可以在实际的数据操作中很好地应用，以避免不必要的空字符串出现在最终的拼接结果中。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* *2* [mysql的group_concat函数拼接的字符串显示不全](https://blog.csdn.net/weixin_37813233/article/details/105664925)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"]
- *3* [MySQL拼接字符串函数GROUP_CONCAT详解](https://download.csdn.net/download/weixin_38602189/12823183)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]