爱玺玺

爱玺玺的生活日记本。wx:lb87626

mysql将收索的结果前后加特定字符,比如引号等。

mysql> select concat('\'',group_concat(id),'\'') from mzm_arctype where reid=(select reid from mzm_arctype where id=(select typeid from 


mzm_archives where id=21));

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

| concat('\'',group_concat(id),'\'') |

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

| '110,111'                          |

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

1 row in set


发表评论:

Powered By Z-BlogPHP 1.4 Deeplue Build 150101

Copyright Your WebSite.Some Rights Reserved.

蜀ICP备11021721号-5