linux中拼接数据会换行,update数据后面拼接数据（适合做历史记录冗余）

参考：-- 询价业务提醒 升级语句修改

insert into T_SITECONFIG(ID,VERSION,IDENTIFIER,VALUE)

select a.ID as ID, 0 as VERSION, a.MODULETAG as IDENTIFIER,

concat_ws(';zf91c8fm;',IFNULL(a.ISEMAIL,' '),IFNULL(a.EMAIL,' '),IFNULL(a.EMAILTEMPLATEID,' '),IFNULL(a.EMAILREPLYTEMPLATEID,' '),IFNULL(a.ISMOBILE,' '),IFNULL(a.MOBILE,''),IFNULL(a.MOBILETEMPLATEID,' '),IFNULL(a.MOBILEREPLYTEMPLATEID,' '))

as VALUE from T_BIZREMIND a where a.MODULETAG = 'askprice';3、group_concat()可用来行转列,Oracle没有这样的函数

完整的语法如下

group_concat([DISTINCT]要连接的字段[Order BY ASC/DESC 排序字段] [Separator'分隔符'])如下例子

mysql>select*from aa;

+------+------+

|id|name|

+------+------+

|1|10|

|1|20|

|1|20|

|2|20|

|3|200|

|3|500|

+------+------+6 rows in set(0.00 sec)3.1 以id分组，把name字段的值打印在一行，逗号分隔(默认)mysql>select id,group_concat(name)from aa group by id;

+------+--------------------+

|id|group_concat(name) |

+------+--------------------+

|1|10,20,20|

|2|20|

|3|200,500|

+------+--------------------+3 rows in set(0.00 sec)3.2 以id分组，把name字段的值打印在一行，分号分隔

mysql>select id,group_concat(name separator';')from aa group by id;

+------+----------------------------------+

|id|group_concat(name separator';') |

+------+----------------------------------+

|1|10;20;20|

|2|20|

|3|200;500|

+------+----------------------------------+3 rows in set(0.00 sec)3.3 以id分组，把去冗余的name字段的值打印在一行，逗号分隔

mysql>select id,group_concat(distinct name)from aa group by id;

+------+-----------------------------+

|id|group_concat(distinct name) |

+------+-----------------------------+

|1|10,20|

|2|20|

|3|200,500|

+------+-----------------------------+3 rows in set(0.00 sec)3.4 以id分组，把name字段的值打印在一行，逗号分隔,以name排倒序

mysql>select id,group_concat(name order by name desc)from aa group by id;

+------+---------------------------------------+

|id|group_concat(name order by name desc) |

+------+---------------------------------------+

|1|20,20,10|

|2|20|

|3|500,200|

+------+---------------------------------------+3 rows in set(0.00 sec)4、repeat()函数，用来复制字符串,如下'ab'表示要复制的字符串，2表示复制的份数

mysql>select repeat('ab',2);

+----------------+

|repeat('ab',2) |

+----------------+

|abab|

+----------------+1 row in set(0.00 sec)又如

mysql>select repeat('a',2);

+---------------+

|repeat('a',2) |

+---------------+

|aa|

+---------------+1 row in set(0.00 sec)