语法
concat(str1,str2,…) 用来拼接多个字符串
示例1:select concat(‘aa’,‘bb’); 示例2:select concat(‘aa’,NULL);
发现如果参数为null,则结果直接为null,解决办法是用ifnull处理一下,默认值设为’’: 示例3:SELECT IFNULL(“aa”,“");
示例4:SELECT IFNULL(NULL,"”);
示例5:SELECT CONCAT(‘aa’,IFNULL(‘bb’,""));
示例6:SELECT CONCAT(‘aa’,IFNULL(NULL,""));