{"id":149,"date":"2019-08-22T09:27:46","date_gmt":"2019-08-22T01:27:46","guid":{"rendered":"http:\/\/blog.adeying.com\/?p=149"},"modified":"2019-08-22T09:43:33","modified_gmt":"2019-08-22T01:43:33","slug":"mysql%e4%b8%ad%e7%9a%84%e5%a4%9a%e8%a1%8c%e6%9f%a5%e8%af%a2%e7%bb%93%e6%9e%9c%e5%90%88%e5%b9%b6%e6%88%90%e4%b8%80%e4%b8%aa","status":"publish","type":"post","link":"https:\/\/adeqing.com\/index.php\/2019\/08\/22\/develop\/mysql\/149\/","title":{"rendered":"mysql\u4e2d\u7684\u591a\u884c\u67e5\u8be2\u7ed3\u679c\u5408\u5e76\u6210\u4e00\u4e2a"},"content":{"rendered":"

\u5c06\u4e00\u4e2a\u7528\u6237\u4e0b\u7684\u591a\u6761\u8d44\u91d1\u4fe1\u606f\uff0c\u5408\u5e76\u5230\u4e00\u6761\u8bb0\u5f55\u3002<\/p>\n

select uuid,group_concat(`atype` separator\u00a0<\/code>';'<\/code>),group_concat(`usable_money` separator\u00a0<\/code>';'<\/code>) from member_account group by uuid;<\/code><\/p>\n

 <\/p>\n

SELECT GROUP_CONCAT(md.data1) FROM DATA md,contacts cc WHERE md.conskey=cc.id AND md.mimetype_id= 5 AND md.user_id=17\uff1a<\/code><\/div>\n
\u5229\u7528\u51fd\u6570\uff1agroup_concat(),\u5b9e\u73b0\u4e00\u4e2aID\u5bf9\u5e94\u591a\u4e2a\u540d\u79f0\u65f6\uff0c\u539f\u672c\u4e3a\u591a\u884c\u6570\u636e\uff0c\u628a\u540d\u79f0\u5408\u5e76\u6210\u4e00\u884c\uff0c\u5982|1 | 10,20,20|<\/code><\/div>\n
\u672c\u6587\u901a\u8fc7\u5b9e\u4f8b\u4ecb\u7ecd\u4e86MySQL\u4e2d\u7684group_concat\u51fd\u6570\u7684\u4f7f\u7528\u65b9\u6cd5\uff0c\u6bd4\u5982select group_concat(name) \u3002<\/code><\/div>\n
MySQL\u4e2dgroup_concat\u51fd\u6570<\/code><\/div>\n
\u5b8c\u6574\u7684\u8bed\u6cd5\u5982\u4e0b\uff1a<\/code><\/div>\n
group_concat([DISTINCT] \u8981\u8fde\u63a5\u7684\u5b57\u6bb5 [Order BY ASC\/DESC \u6392\u5e8f\u5b57\u6bb5] [Separator\u00a0<\/code>'\u5206\u9694\u7b26'<\/code>])<\/code><\/div>\n
\u57fa\u672c\u67e5\u8be2<\/code><\/div>\n
mysql> select * from aa;<\/code><\/div>\n
+------+------+<\/code><\/div>\n
| id| name |<\/code><\/div>\n
+------+------+<\/code><\/div>\n
|1 | 10|<\/code><\/div>\n
|1 | 20|<\/code><\/div>\n
|1 | 20|<\/code><\/div>\n
|2 | 20|<\/code><\/div>\n
|3 | 200 |<\/code><\/div>\n
|3 | 500 |<\/code><\/div>\n
+------+------+<\/code><\/div>\n
<\/div>\n
\u4ee5id\u5206\u7ec4\uff0c\u628aname\u5b57\u6bb5\u7684\u503c\u6253\u5370\u5728\u4e00\u884c\uff0c\u9017\u53f7\u5206\u9694(\u9ed8\u8ba4)<\/code><\/div>\n
mysql> select id,group_concat(name) from aa group by id;<\/code><\/div>\n
+------+--------------------+<\/code><\/div>\n
| id| group_concat(name) |<\/code><\/div>\n
+------+--------------------+<\/code><\/div>\n
|1 | 10,20,20|<\/code><\/div>\n
|2 | 20 |<\/code><\/div>\n
|3 | 200,500|<\/code><\/div>\n
+------+--------------------+<\/code><\/div>\n
<\/div>\n
\u4ee5id\u5206\u7ec4\uff0c\u628aname\u5b57\u6bb5\u7684\u503c\u6253\u5370\u5728\u4e00\u884c\uff0c\u5206\u53f7\u5206\u9694<\/code><\/div>\n
mysql> select id,group_concat(name separator\u00a0<\/code>';'<\/code>) from aa group by id;<\/code><\/div>\n
+------+----------------------------------+<\/code><\/div>\n
| id| group_concat(name separator\u00a0<\/code>';'<\/code>) |<\/code><\/div>\n
+------+----------------------------------+<\/code><\/div>\n
|1 | 10;20;20 |<\/code><\/div>\n
|2 | 20|<\/code><\/div>\n
|3 | 200;500 |<\/code><\/div>\n
+------+----------------------------------+<\/code><\/div>\n
<\/div>\n
\u4ee5id\u5206\u7ec4\uff0c\u628a\u53bb\u5197\u4f59\u7684name\u5b57\u6bb5\u7684\u503c\u6253\u5370\u5728\u4e00\u884c\uff0c<\/code><\/div>\n
\u9017\u53f7\u5206\u9694<\/code><\/div>\n
mysql> select id,group_concat(distinct name) from aa group by id;<\/code><\/div>\n
+------+-----------------------------+<\/code><\/div>\n
| id| group_concat(distinct name) |<\/code><\/div>\n
+------+-----------------------------+<\/code><\/div>\n
|1 | 10,20|<\/code><\/div>\n
|2 | 20 |<\/code><\/div>\n
|3 | 200,500 |<\/code><\/div>\n
+------+-----------------------------+<\/code><\/div>\n
<\/div>\n
\u4ee5id\u5206\u7ec4\uff0c\u628aname\u5b57\u6bb5\u7684\u503c\u6253\u5370\u5728\u4e00\u884c\uff0c\u9017\u53f7\u5206\u9694\uff0c\u4ee5name\u6392\u5012\u5e8f<\/code><\/div>\n
mysql> select id,group_concat(name order by name desc) from aa group by id;<\/code><\/div>\n
+------+---------------------------------------+<\/code><\/div>\n
| id| group_concat(name order by name desc) |<\/code><\/div>\n
+------+---------------------------------------+<\/code><\/div>\n
|1 | 20,20,10 |<\/code><\/div>\n
|2 | 20|<\/code><\/div>\n
|3 | 500,200|<\/code><\/div>\n
+------+---------------------------------------+<\/code><\/div>\n
<\/div>\n
\n
\n
\u4ee5class\u5206\u7ec4\uff0c\u628acategory\u5b57\u6bb5\u7684\u503c\u6253\u5370\u5728\u4e00\u884c\uff0c\u9017\u53f7\u5206\u9694<\/code><\/div>\n<\/blockquote>\n<\/div>\n
\n
mysql> select class,group_concat(distinct category) category from yuedu group by class;
\n+——-+———————————+
\n| class |category |
\n+——-+———————————+
\n| 1 | 1,2,3,4,5,6,7,8,101,102,104,107 |
\n| 2 | 1,4,6,7 |
\n| 3 | 1 |
\n+——-+———————————+<\/div>\n<\/blockquote>\n
\n
<\/code><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\u5c06\u4e00\u4e2a\u7528\u6237\u4e0b\u7684\u591a\u6761\u8d44\u91d1\u4fe1\u606f\uff0c\u5408\u5e76\u5230\u4e00\u6761\u8bb0\u5f55\u3002 select uuid,group_concat(`atype` […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"_links":{"self":[{"href":"https:\/\/adeqing.com\/index.php\/wp-json\/wp\/v2\/posts\/149"}],"collection":[{"href":"https:\/\/adeqing.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/adeqing.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/adeqing.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/adeqing.com\/index.php\/wp-json\/wp\/v2\/comments?post=149"}],"version-history":[{"count":6,"href":"https:\/\/adeqing.com\/index.php\/wp-json\/wp\/v2\/posts\/149\/revisions"}],"predecessor-version":[{"id":156,"href":"https:\/\/adeqing.com\/index.php\/wp-json\/wp\/v2\/posts\/149\/revisions\/156"}],"wp:attachment":[{"href":"https:\/\/adeqing.com\/index.php\/wp-json\/wp\/v2\/media?parent=149"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/adeqing.com\/index.php\/wp-json\/wp\/v2\/categories?post=149"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/adeqing.com\/index.php\/wp-json\/wp\/v2\/tags?post=149"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}