Shulou(Shulou.com)06/02 Report--

Today, I will talk to you about the role of concat and concat_ws. Many people may not know much about it. In order to let you know more, Xiaobian summarized the following contents for you. I hope you can gain something according to this article.

select concat ('large ',' small') as size from Table

The query results are: Size

select concat ('large ',NULL) as size from table

Query result: null

Another parameter in concat is NULL, and the result is NULL.

select concat_ws ('_',' large','small',' medium') as size from Table

The query result is: Large_Small_Medium

select concat_ws ('_',' large','small', NULL) as size from Table

The query results are: Large_Small

After reading the above, do you have any further understanding of what concat and concat_ws do? If you still want to know more knowledge or related content, please pay attention to the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.