基本语法:group_concat([DISTINCT] 要连接的字段 [Order BY  排序字段 ASC/DESC] [Separator '分隔符'])

  初始数据:

                 aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAMMAAADTCAIAAACzyzBmAAAN50lEQVR4nO2dzW7buBaA+TiDrAPD9hvc5hmmBRxHmDxH2gL5aatHuL2Li3blOkA1aNMsZ9HbXdoauJF2g5nBoO0gd6aJk04b3YUkiqIOKdkmRR3lfODCZWjrkPpEya6OyM4ItIRh6DqEHOY6AGJ5yCSig5BJhBlyk+IqoiiqbGMPt1tfkSiKfp7HXSrl3UEmNQGZJA+HnXGuBZnUqkImuYFMkofDzjjXgkxqVTFkUvhowAaPwlKLwAOrjUAmtaqQSW4gk+ThqGhBJim4WSbNL7/oSxRFFW2mY9Y7eFf1OcuV6q23uERRdPwp7lIxZNL7gx4bP0vrD0dMoAmTDkesv7c/Tje4PxOiShlNhZbTtH40/TKflt4lxC9U2jMp2GCD7aeP1hhjjG08jY+fesnW1+6GQhuOd198411d47W74fGncHtd+OtTj60/+lfDJl3Mr/QliqL09bv9HtuczK8u5tMRY6NnaYPJiLHe/tuqz1mu5FufT0eMsdE0i6S3++7qYv5+d5Rt+tkmE8JLQ3q2yQrv4g2St19dzN/v9vK+GA++sOOTvZs4dCc4/hQfv3m0lkoTbLCiCkK90Hiw/SbT603yyeH2eqZmZs/9O2zjaeNz0jImPdssqCP906JJ4u7nr6/e7vFZqSwK9DrRS5xS995bCv7Vx+tXH69ffXy+wfrb/1G/frLF1h8+Thtfv/p4ur3ONp5IjU+317PGRdZ2ToWWzzfY1v38o0yW7pr0br/HPYCnHIVJ1gI2ZxLXAjKp0Dgtj3f6azunj3f67PZzGxpVmHR+cakvURSlr9/u99jm5OLy/GI6Ymw0SRq83+0x1ts/qfqc5Uq+9YvpiPV23/KN9nbfXp5PNvmmT3Z7LA+PtwRfi/FfTkbJu6wEf/Th+ujD9dGH57dY/4fXmtfPbzG2tnOatn+yxdYf/lNufPrDet741pOk8vre7a17ybteP1xb37q1ztubL8ZNujyf8BNEb3d305lJicdJHKPNXl2Tkr5k1+mTVYM0YVLqR0YmB2zS9dHrh2tZU67U0Yfre7dZpmDjJn0+n+tLFEWVbewVt1tfPfiXf3xrsty9w7679197n68z6a/PF/oSRVFlG3vF7dZXD/7lr9+aKz89/I5t3bW5CTLJWfAvfv/aTNn5njHG/vFvu1vRmfTnX+f6EkVRZRt7xe3WVw/+xS9fu1R0Jv3vz8/6EkVRZRt7xe3WVw/+x9/+7lIhk8gk+yZFBLEISpPiKspvbpI6EbYW1MGDlHtEJjUB6uBByCQ3oA4ehExyA+rgQcgkN6AOHoRMcgPq4EEwmBR4jDEvkKtR7wwMwQdedr9vAFQO/WKmR8tNCv0hY0PPG+pNCn2oQZtpvUmhP0xHNPC4S6E/zAwSahN0JtW5rb2JTilEIZMaIvBSfQrDLI95B0zi8y0Tjxcmz8yBx4Z+4A95bdZKnqYbAZFJXKQ48MTdkNfHcaw3qc7NyI30ZaE5KfBEOfJJOPC4NYlDSbWj6QyBSaFw1PGKG2SS1L/8T+IfVK+bA4FJGfmhebPmJMAkPgxk0nJkQ1QYqkWuk+rc1t5IT1Y7u+UneTKpNvlXN/ELm+aIbbtJ2bm6dP0shZ62q7ziJpNqIwy9MOp5rXxo60yqkyBhv0dK2r8zNKAOHkRnUp3b2p0EnYB6Z6AOHoRMcgPq4EF0JtVJkHASdALqnYE6eBCdSXVua3cSdALqnYE6eBAyyQ2ogwfRmVQnneCMIDKUJlVqSHPS0qAOHoRMcgPq4EHIJDegDh6ETHID6uBByCQ3oA4ehExyA+rgQVpvEvxf0nGMfGcgCB4eeay5JYHHAy7dpCRESBkBxgFHHn1uSQK/+7EcOplklWzk8eeWJBTvIqbckubIRh7/fdxA3LFyTqLcEsPA6W5ITSqdlKXQKbfEFoWRxz4ngRrFC5hEuSVLIo885twS4ctCibpnN8otWQZw5PHmloiXzqWLYzF0yi0xjGrkKbekbaAOHkRnEmUE2AN18CBkkhtQBw+iM4lyS+yBOngQnUmUEWAP1MGDkEluQB08iM4kyi0hFkJpUqWGURRduePs7Mzh1lcEdfAgZJIbUAcPQia5AXXwIGSSG1AHD0ImuQF18CBkkhtQBw/SfpOm4/Q/n8fTUuj2t24LDMGDI88r+wezQuuWmzQ76KfdmI5ll4SdMTvol0RrN603CRz52UE/M6i0P3Qm1ckIaK5r07F0GJBJDcFHvjDM8pijMakkEt8ZfL5l4vHC5Jl5Omb9g+lBn9dmreRpuhEQmZSP/HQsuiPtEZ1Jde7jtt6PmbDviyjmpOlYlCOfhKdjbk3iUFLtaDpDYFJp5KWhwmaSEHets5s8d/E/iX9QvW4OBCZl5COPe04q9Kiwy2ubxIeBTFqObIgKQ7XIdVKdjAC7Xci/QIhfG/LQhXbqs1t+kieTagOPvOaIbblJ+cm64vektFnlFTeZVBt45PNaYHcoTaqTW9Jw96TQHW59RVAHD6IzqU5GgNvQHW59RVAHD0ImuQF18CA6k+rklrgN3eHWVwR18CA6k+pkBLgN3eHWVwR18CBkkhtQBw+iM4lyS4iFUJoUV0H5bkuDOngQMskNqIMHIZPcgDp4EDLJDaiDByGT3IA6eJBOmKR7GiWI+yfBk0kFmjMp9IelR7CTSVYpPGmy+IDz8jM/YyQmhf5wOCzJssLOIJOqgZ7kinzdkuSJ2to1Apb4SDKpAsAk3OuWZE9m15kkdqpiLSkmL+WStG9cKxQmyQOJeY2AfJfXMyn0PeE528KKJcX3Zm8o/6Up2m8Sh5/SEK9bIj36v9acVJ6VVNO0p1jFohEQmZSPINo5SVCiNNHGoEniVzxw6Rvxk4GL+ObAahLadUtyas1JQqPQH4pnNz61+eI8LTRqmNabFHjAQjB41y0RqHudlE1jQ8+DLsPLi7qJi701R+tNUvxy1PF1S9x/qV8YBCYtiM4kLKtNLPwTdwsgk1pmUjoDI5uQ4ptmEq1bYg/UwYPoTKLVJuyBOngQMskNqIMH0ZlEuSXEQihNqtSQ5qSlQR08CJnkBtTBg5BJbkAdPAiZ5AbUwYOQSW5AHTxIJ0yijIAW0HaTFBkOcUwmWaZruSVQhkPKCjuDTKqma7klZJIrupZbAmQ4lEOn3BILdCy3JKd8LQSZRLkl5ulCbkkRebqF5yTKLTEP+twSiRomUW6JFbqQWwJmOJRCp9wS83Qvt0T5+wXllliGcktQgMCkBdGZhCAjII5jyi1pB8hNotyS1qAziXJL7IE6eBCdSZQRYA/UwYOQSW5AHTyIziTKLSEWQmlSpYZRFJ1/iV2Vs7Mzh1u/ycGrekQmUfBmekQmUfBmekQmUfBmekQmUfBmetQBk4IR8yauh3LZ4DtSMJh0yO8DLehCJjVRZn6fsf6DUBjq9A6BvZnco3abdOixgX9SsTPIJEsl3BsM+wNuUrjHXx965QNbaVKdjIAGeiK5D+0MMslKOXkw7D8IJ+PMnpnfz8c53Buw0WGhRy02aeb3B/7eOJ1PhTlW2hmiSXz6Bedk+UNcFQQmzfz+wD/5EucmHXpsHPAGeX3WI6VJde7jttuZQ4+xTPyZ3y+emyGTglHehh80YKXj0nqT8oHixpw8GGI2SbhIKoeevc5MOhQzkLMZCKx0vatabpIoTSfmpGyCVYWevRZMKl+eq6/ZHZZ2mxTuDZjMOCiO5CLXSXUyAhroknC5V+fslndvMtZUOi7tNqlQhANYsKd0fLbcpFi8WJaub+Ar7pnfL7cHK50WnCaJIykfkDqT6uSW0M64gcGreqQ0qU5GAO2MGxi8qkdkEgVvpkdKk+rkltDOuIHBq3qkNKlORgDtjBsYvKpHZBIFb6ZHSpMot4RYCKVJcRWU77Y0qIMHIZPcgDp4EDLJDaiDByGT3IA6eBAyyQ2ogwfphknFh7JigEwqYNsk4XnIwCMPySTr5E9358OLdt2SnNLDJMkkuyiePo113ZJCJ4q2kEk2Cf0huAAO2nVLMoADRGGStESJptIlbTcp9IdD35fOZF1YIwBaUgkySWwHLhLQlgcut92kwMsvjrJzWgfWLYF3P2BSIKeRDP0QrnQNApOKU3o6krhNUswjsEllTTRLxLmj7SYVL5Nyk9CuWyJ0o4Ti7CZeMWkqHdN2k8SvaflL1OuWqBcAgK+4wZUC4eUDXdJ6k2Lw16Sur1uCENTBg+hMQrDaBFpQBw9CJrkBdfAgOpNo3RJ7oA4eRGcSrTZhD9TBg5BJbkAdPIjOJMotIRZCadLP81hfaE5aGtTBg5BJbkAdPAiZ5AbUwYOQSW5AHTwImeQG1MGD1DKJMdZuk+juW/fUNQmUqal7AeD/fSaTrGMqt0QyqSyTfZOEW4tKt5eQSXYxmFty/ClOinjrKq88/tSMSbw3cs/IJJsYzS0BTRJlauDsJt6NLvVMYRLllpjAbG6JyiQuUyNX3PxCSXOTHuWWmMZsbsmrj9dJkTTi9Y2e3epcJ1FuiSnM5paAJvHKJkwC+wOETrklpjGbW3L04TopXCNekxTrJhXmIfnbguLsRrklRjCaWyKZJGnUhEnFx5XU+j2JckuMYS635OUf35LCGOOvxdKa37jxgTp4EK1Jv37TFzJpaVAHD6Iz6cXvX/WFTFoa1MGDaE365au+kElLgzp4EJ1JP/72t76QSUuDOngQMskNqIMH0ZlEuSXEQihNaspmopuQSYQZyCTCDGQSYQYyiTADmUSYgUwizEAmEWYgkwgz/B+Kdqyao0UXgwAAAABJRU5ErkJggg==" alt="" />

  以name分组,将money打印在一行,默认','分隔:

       select aa.`name`name , GROUP_CONCAT( money ) money from aa GROUP BY aa.`name`

    aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAArsAAACzCAIAAAAGzUORAAAY10lEQVR4nO3dzW/cxsHH8fl7clvDK6g8JdfmHtkXWZUVIvkTKkGnynose5HsRQcJMtD2EMh90NqqkW1dOb44F7tWAju2YGS3lxStUDjqI1tvfknM58C3ITl8XVKcpb4fEMmKO1zOkBTnxyHXEpZkL2ips3x4eLh9yix1lq1GW+os7wEAkJOQ+5LQe0ud5YODgyenDIkBAICo9MTw+JQhMQAAEJWSGPb39x+dMiQGAACi0hPDt6cMiQEAgCh1YljqLJ/mqa6+/GTUvnmZmJiYmEZxUieGujozAACgJxIDAABIR2IAAADpSAwAACAdiQEAAKRTJ4Y3FbAsK8t/AQCAhk4uMRAXAAAYXYwxAACAdIwxAACAdCUnhqc3L1++fPnavZ0CcaFwaPjhlvX+lPX+lDVza7iNUaN+1xBm7/SstyRdQziMbs80un3L6plCZnTl8v6b7nxvjtHt972PM7qBD3cLpNZH/vx+1/C2bNx67c8MrTfmc6SGSY3qh2oZU9OukaX6mul3jeDuG0Vfrzhnp/enrMWtumuT0xfzTs0/mLe+XrG+2LGsLb859nyZ11hvvjdn5pZ/orbf9T48y9nbW9b5hCnrix1/vvej/ZkfrJS/KdRO33m7zMSwc+/a5ZtP3zy9qUwMFcUFzw+3SkgMX8xbXw/7GUX1zGy9UlPWO7Se6de73zW8VvSl7lEu0zOF91vW7xpS9yw3v2f6vVTPlH4tUzvd8Oe7PyWs1zCkN+S4oPocr5hcYa+xXl0V9Qy0Y5SMbMVdO9bMfHopPX294p9Rf7gV6KS9+XKZr1f8rvqHW4HQYC9oW5Q2yOKUf779Yj5QLOqHW1Lk2pLCypZ05t86wbhgO2Xn7QruSsQkBivPGIOcbf1fuR1rJibbWsrEEF9ezsLOkSoVznpBELjq66fPz8PpKkzvo6QzZ/Tz7dKGYdolnQLBbkd1zR1lZ/bFFT/L+xFqK3JBsGPNTFkfzFuLdsmt4CKJ+2tY8RegcmKwvCv9SHmvN8qYGOQxA/ValW8nr7fr/uAVS1yN82awxoq6BqVfjyQfP4HhFmdm0vGpPN6cmYEDNvVozDrMoGX95dEF+VfAPrl519wfBHvNwO9d8u9XnFLOS/FZJ3Cm3bFmVtTlv15xTqEZE0MgEMSsN5AYpGTwxbzz1mLqxrGaed4+MSeXGLLHhVCGlX/TvCNPzrDRpZLLh7PwlF8s3xhDryefkvxDI25+Tv2uIZ/g/INY+fleafcS1et6Qh1oltDgnZUCW3UrcGpzfnt3rBk7XW05S3m/2Mn7a1iqXtMmbytv+/Sjl97uJ5QzxhBTn9T1Oj95XWN8uyzLcnepXElVXTO+E6po7PEjnUB7pnf8xB2fscdbsGnJAUyqfLazt571j+t3t6QMseX/vgSulefdT4j5/YpVynlpK3bIVj4neOcBxQWb+wkljjHIdyVCJ+rFKWtmPtt9n4aet0+GpmMMi9EjIzIGEDpowodsfPnF+K4rX2II3kMOXI0q5+cUuNoMjURHP1/qcuxZzuKKG90pNQpl+cD1RHQMxjsnuqnfWTxtfw3L3yBSdHcbHr1WKJoYRPSj0uoTkL5ee8dlSQxS1x9NAbG5IOMtz4TjJ7i0V0H18Zl4vPlLJAYjWdZzt571j08MigHR4HC609HG/X4lKOW8JNXQPxu7FYg+fFA4MWR8jsGKjjFMBRNG9vsRDT1vnwwdxxgCpPtVCT29pTpk48qXlBgCVz99+Vyinp9bzJEX8/lxR57qejRZXGJYnAqMGaQkhrT9NazEnsB5FXoiIMtdiUCxPLfR48bPM6y33zXMrnRXImZ/hZ7pFOHm65EYko83t1j2X4uTTgzl1r+GxFDSeSmuPvKZdit4RZflrkSwWKabCK5Qw8PbIWtiaOx5+2ToOMYQGJ6SjgP5KZuoaGKIKx+avyg9suCveivtmlg+s0fGoRTzHT0zc1qMvQZKXm/4yMs+sOtQJ4ad8AMlqYkheX+p5dg84dsEisQQ7C7jnkCUywS713wP3gW3s7+2DE9c9kwR+KKE6nPCZ5DQOa2EuxIxx09wO/vViLuWSj7euobZyzzAkO+uhIb1z54YIsPyi95diVyJoeB5SSFUH0VisO82Sudn5ZOPchn5tTVcYlgsNsbQ3PP2ySgzMdhfrfRdu5c3NNjkb92Eum3lW4vxo99xHyXPDwXV7EPo0riRYZr+M+1x8y3Lyn7keR/i3uISIvplPO/zr0mlnd7H+a6gdys34+iWN+Ro3zqVBwz9L0e5j0Yubjq3Hj5YcQp7z3N5t2Zz3ZVw655WLrSN5GZJX5e0S9nfopA+P/BuwnzVzY0UcoXkrZz8rU7nZ/Wq3XubgeKBpVMHU7M++Rh3/KhWkHB8WsnHmxygUsWPuOhf/9C3B73+LHS+8s8/0bt+Oym/X8kbI895SSVYH6f+3hlSerws+l3K1G9dWsHHPJOfYLAi364M3MVQ3i2N18jz9onh33yERgIPqaEsWn1JMccAg14Vd+SpP9Aw/JuP0EbGO+7IT4d/wUl+DiPfowl6yF1/oHEYYwAAAOkYYwAyU3zliWtOAKcFYwwAACAdYwwAACAdYwwAACAdYwwAACBdyYnh3jXvX28K/7OPFmMMAACMrJL/zUc3KDy9efnyzafhAhZxAQCA0VTVXYmde9dCicFijAEAgJFVUWJ4ejPyRyWICwAAjK4KEsPOvWuFbkkQGgAA0FbJiWHn3jXVU49ZQwMAANBT2X/tWnUzImNcIDQAAKCt8hLDjvfNSgfflQAAoDH4Nx8BAEA6/s1HAACQTp0YAAAAZCQGAACQjsQAAADSqRNDdXdBilnqLGs71b1tAAA4CSOTGOqugpq2FQMAoFxJiaH2y3f9L+Vr3yx6TnXvFgBA+VISw0960LYT0moTaVIZbXcWAGAY6YnhpQa07YSWOst1b5uXL1++/ElKDDrUpO7dAgAoH4lhKCQGZU3q3i0AgPKlJIa3b9++0EBiJ9QzhdmTfu53jcDPltXvGiKG0e0Ps/mWOst1b5sXL168ePv2rZ0Yat9fdk2G2aQAAD2lJ4ahvrz5v1Nj//PNUJ+wt7e3t5fQCfW7RqjXVyYGr0zca8uyrJ4phAgtm2ypszx864YnJwYdapJjCwIARkR6Yvi/qD9Miak/+K/bi99EC8TwlsslvhPyBhhixhGMbj/TGEO/awhhmKaROzGoN843i223xVPSxmgvfuNvPL+MCJTIv33kxKB4+5vFtr/dAz8o/GGqUBUCNcl9GAIAtJeSGN68ebMbcf1C+8IFRWcnhBDtSw93d3evXxAXrqsWVM5OF9cJucMJgcGC4mMMVr+bPzGoG/nwUrt96aHU4usX7E1jl2hferjrlglt2tCcTN68eWMnBuX+2n14qe1v94eX2heuP7zUjtkVikrlr0mOLQgAGBHpieHHkAcL7fbCg/DcoPXJuGv6yfXkJdXiOiFTGilQDiQkjj/IYwy2IolB3e52241Uk+vrk5PrP65PSlvtwUJ7cl21JQOlspMTgzz/wUJb2Cvyt7v7g/Ne0s4qsMtIDADQVOmJ4XnA/YW2aC/ct18oOhe71Pqk91IWMztd4nMM3TxdvOK5h+CbuRNDqKr3F9picv35/YV2e+H+8/VJMbmw0J5cf74+2V64HykanqcolYWcGILvrE+K9sL6Qtvf7vflH8LuL7Tbk5OTReog1yTPDgEAjIaUxHB0dPQPyd35M0KIM/N3/5Hs2vm4C9bz11IWVYrrhKSxA7OnGEkwe4kDDFIpW5HEEKypvYXE+fn5M2fm7/7j2nlxfn7+/Pzdu/NnIk13ygalb1yFo6MjOzGE9pe9kjPnz585P69aWXBtd+fP2Pvnrl35Iuya5D8OAQC6S08MfcnauXNra+dac3f6/TtzrWgHdG7NLee9DC6unJ0uUycUfn5B/TyDaRqGaZrqYYYiiSFQ0Ttz51otcW5t7Zy/Tc6di26htXOtuTt35lqtuTv2RrFf952Nm5ecGBRv35lr+dt97ZyIruPOXEuI1tzaXMt505mRuy4kBgBoqvTE8H3I2kRrbjM8M1Im7np+Yi1lUaWkTsgdQzC7CYnBLuQ87mB0+/bPkXBQJDHI9dycm5ibmxATa99vzrUCm2lzriU1Xd6G9utw+XzkxBB5c21C3u6bdhTYDL7tz5ArsjnXEsHCGWuSYwsCAEZESmI4PDx8FrI60Zq9/ezZs1VFKphYDZcuR9KTj/I3H1T3G3qBQoHnGHqmVyq8cMbcsNRZDmyb2dnbqxNiYvXZ7dlWa/a2u62erU4IMbH6zHvP31D2LKd80e1zeHhoJ4bI/lqdEK3ZVX+FqxNiYjVQgUj5oXaiXZPchyEAQHvDJIZQF+d1NvYL+/3bsy0hhFuyaL9Y0l0JZ+6Q/86jLJQY/Nbfnm21Zmcn7Bi1OjExO9tyt4m84bwNIr/I32XHJQY/jnh7xot70lrcGOG95+ecvLuLxAAATVX+GIPbGYUThdMjFQoN2nZCsYlhdcLZHLdnW/64wupEa3Z2Qrrej2apUhODw/5MpyZ+Ne2f3NmhHePvrlyDDiQGAGiq9MSwHbLyUevXf5X+L70hPlrxf/zrr8OPRsrv5qNtJ7TUWY5uH6mh/g8rHwkhhL/JVj4KbhD7/YKbSU4MiredXRH+4FAV/BrYQrs3T03q3i0AgPLlTwx10LYTUiSGOqQkhhOvSd27BQBQvpTEcHBw8EQD2nZCS53lurfNkydPnhwcHNiJofb9Zdek7t0CAChfemJ4rAFtO6GlznLd2+bx48eP5cSgQ03q3i0AgPKlJIb9/f1HGtC2E1rqLNe9bR49evRof3/fTgy17y+7JnXvFgBA+dITw7ca0LYTWuos171tvv3222/lxKBDTereLQCA8qkTg939aDXVtYGS1b5ZmJiYmJiYTmZKGmMAAACwkRgAAEA6EgMAAEhHYgAAAOlIDAAAIF3BxDAYDP55bI3oNBgMKtue9WheiwAAuiExNEHzWgQA0A2JoQma1yIAgG5IDE3QvBYBAHRDYmiC5rUIAKAbEkMTNK9FAADdkBiaoHktAgDohsTQBM1rEQBAN+rEcPzqTfI0GAy+2rVGdBoMBqkNHK2JxAAAqNrwiaH3ofjFpwumEEII8d5C35n/98/fE44Pr0slrzvzP7xufXU9stRu70N3KWlmdYnhz9Ni/MpGZ0wIIcT0xpvjjRl77WNXt6Uynpmb8oJXkwqPXd0+frV9ZUx6d2NGjHWekBgAACNInRiOjl8nT8HEIMSFnpsSfvHp362vdvufXvj893aB66YQ5qJX8uznv991s4K/lFfAXtz6arf/6VkvapSfGNyGbEwLIcaufnf8+ujmRTs1HB2/PnpydUxcvOEWGLvy1Cl/86KQ5kuFx5ae2DPtF6+Pjp8ujYnpm6+Pbl50Pv/49Y1pMX0zZcMWm0gMAICqFU8Md358d+fHd3d+/PJDMf7pA/v195+e9V6/+91vxt3r7Y8XwyVVr9c/FkHv/eZ7dy1lTsHE4PXxqtdSfx/IAeFw4BYOGrvyVCq5Me2kDRIDAGD0VJMYHnz2ntffP/jsveyJ4exnv6sgIpSaGJTDCcrCzvTdlbGxK0+/uzLmjEmQGAAAI0idGA6PXiVPg8Fg8/m7zefvNp9/+Usx/sl9+/X3n5wd/+T+u831j8XZz377/N3m83e//c24EB9fCpdUvv7yl0L8ct2e+e7SpL1U+dNgMHAbsjEtxpa+S3i9MS3E2NJTp/yNi2Ls6uNw4adLY37h6RvOJroxffGGvdR3V8fGLk6PeeXLn0gMAICqVZMYnn//yVn3zsLkx+9lTQzvNu9/5j0v6UWHWhODkwNcbghQJ4ZXh99dHXOLetHh8OjVjWnhRg0SAwBgJKkTw8HhcfI0GAz+9t+fR3QaDAapDSx3+tO0aC89qe7zSQwAgKqpE8P+wVHyNBgM/vbvn0d0GgwGqQ0sc3q01BbTf6xyFSQGAEDViieG2//5aUSnk0wMf/yVEEL86k/VroXEAAComjoxvNw/TJ4Gg8Htf/00otNgMEht4GhNJAYAQNXUieHFy4PkaTAY/GXn7YhOg8EgtYGjNZEYAABVIzE0YSIxAACqpk4MA4yaug4gAMApUfyvXVdWpcplaeBoaV6LAAC6ITE0QfNaBADQDYmhCZrXIgCAbkgMTdC8FgEAdENiaILmtQgAoJuhE0O/awij28++xn7XEGYvTx3L1rz+tXktAgDo5rQnhp7p/2FKqR3ebEXTCixSNRIDAKBqJ39XQrvEEOnhpRDUM0WksgUWqRqJAQBQNXViOH71JnlqcmIIVFBR2wKLVI3EAACo2tCJQe4f+13DHa2Xukx/FN/o9gML2OVPPD7E3JVw69EzQ7UP5YMCi1SNxAAAqJo6MRwdv06eVImh3zXdftIfme+Z4Rv77gLRd06Ksn/17iuEhggSuv8Ci1SExAAAqFqJicH9Sb7+jhvBN2u42e+J6V/duuYYMCiwSCVIDACAqpWXGPpdwxs08GbGJAZhGDm/YVGm9MTgVy35oYQCi1SCxAAAqJo6MRwevUqeFIlB6jX7XUO+K+Hd7e/KQ/hSoRMm9a89U3oUIZJ3lImnwCKVIzEAAKpWXmKQ7kgYpql6HNIvJve5NX8XUfnPKITrrKp16iIniMQAAKiaOjEcHB4nT3HPMYyEIv1r8EkF3ZAYAABVUyeG/YOj5MlLDLn/yUcNFOhf+11D48BAYgAAVG6IxOAMzuvck6o1r39tXosAALpRJ4aX+4fJE3+7UivNaxEAQDfqxPDi5UHyRGLQSvNaBADQDYmhCZrXIgCAbtSJYZDBHnRS1wEEADglTv6vXdevef1r81oEANANiaEJmtciAIBuSAxN0LwWAQB0Q2Jogua1CACgGxJDEzSvRQAA3QyfGPT+iwsqzetfm9ciAIBuSAyWZTl/eVL6+xjKP08p8d73217BIsO0CACAUpEYLMvqdw3D8P+ilvTXtXqm4g9n9MxIF1/BIkO1CACAkqkTw/GrN8lTkxJDv2sY3b7fpwf+fnf0j3nbxYOfWP4iQ7UIAIDSlZsY/JF31Qi/Ln8WO9C/ur25nxiCESg8OtDvGka3G7qdUPoiw7QIAIAKqBPD0fHr5EmVGORez7toVs6smdS/+lXyKhqqZbgv75n+kwjujYXyFyneIgAAKlFeYvCHEqSLaeXMunn9q9xtZx1jCP7s/FT6IkVbBABARUpNDNFOb8iesBpu/9rvGiLM7AXrHBkXCT6T4Hf/5S5SsEUAAFRFnRgOj14lTzF3JeQnGhJm1kzZv0o9uNR/J3/HwX9Z+iIltAgAgBKVmBgCF+1+NFDOrFVaYpDrLDdN8YCnqplDLFJqiwAAKJE6MRwcHidPp+5fiS7wHdIT/NopiQEAUDV1Ytg/OEqeTlti6HeNvL1/gUUKIzEAAKpGYmiC5rUIAKAbdWJ4uX+YPJEYtNK8FgEAdKNODC9eHiRPJAatNK9FAADdkBiaoHktAgDoRp0YBhnsQSd1HUAAgFNCnRj+eWwlT4PB4PXI2tvbq7sKJSMxAACqRmJoAhIDAKBqJIYmIDEAAKpGYmgCEgMAoGokhiYgMQAAqpaSGIQQJAb9kRgAAFVLTwzK0NCgxLAx4/wByZkNxczxznZk+e3OuIguk7hIgbXkbFFdBxAA4JTIlBiioUFKDNud8UA3qD8pMWx3xp26b8x4vfl2Z9ztw6W5ro0Zr3/3m568SIG15G5RXQcQAOCUUCeGr3YtexISb+ZXu41JDJKNGacDDzQouXXbnfHxznaeRYqsJR2JAQBQtRyJQQ4NbmLwxtWFfL0cGbPfmBHjnQ1nMH9mwy817HB80f41OtPryl9vzIRuNsRX0i2aeZFCa0lHYgAAVC1fYvBCQ8wYw8aMHAL8wfaNGS8d2FnBH8uvYXgikBi2pRzjzcjZ/acvMsRaMraorgMIAHBKqBPDnR/f2VMoLnjz1Ykh3O95b8lvxL0+OXFjDH6mydCXB549yDPGkGstGZEYAABVy5EYvJl5EoPXPeqeGPzKBCqlHgYJP6qYYZECa8mOxAAAqJo6MWw+f2dPXlzw5thT1rsS/k17LROD/yUG+asLCRkoWDA4M3aRImvJ3aK6DiAAwCmRKTGE4kIwMbj36FOffNQwMcT92wr+XLmrd2+wBLj1T1gk+1qGaFFdBxAA4JRQJ4a//fdnexJCeK/lqUH/glM2wccOqlqkKBIDAKBqMYnh3z8nT6ctMUg3FipcpDASAwCgaurEcPs/PyVPpy0xaI7EAACoWkxi+NdPyROJQSskBgBA1dSJ4S87b5MnEoNWSAwAgKqRGJqAxAAAqJo6MQwy2INO6jqAAACnhDox1FUbAACgJxIDAABIR2IAAADpSAwAACAdiQEAAKQjMQAAgHQkBgAAkI7EAAAA0pEYAABAOhIDAABIR2IAAADpSAwAACAdiQEAAKQjMQAAgHQkBgAAkI7EAAAA0pEYAABAuv8HQIFr0ph8aYkAAAAASUVORK5CYII=" alt="" />

  以name分组,将money打印在一行,用';'分隔

    select aa.`name`name , GROUP_CONCAT( money separator ';') money from aa GROUP BY aa.`name`

    aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAvIAAACpCAIAAADGL04GAAAZDklEQVR4nO3dzW/cxsHH8fl7clvDK6g8Jdfk4lNkX2RVVojklmsl6FRZj2UL8V58kCADbQ+G3KetrcfIto4cI4B9iF0rQRJLMLIsEKRPK7SO+9iWtLIlx3wOfBuSM3zZ5Ypc+vsBkay4w+XMkN757ZAriYNC2bad/F8AAIABEUeZaUg2AABgcIqMNWQaAABQotyxZvP6uXPnzl2+s91Dpuk52fx4w357wn57wp66UVTDj1ynZQiz/ebstyAtQ7iMVts0Wh3bbptCZrTk8sGT3np/jdHqdPyXM1qhF/cKpNZHfv1Oy/B7Vrdf5zUj+9W8jtQwqVGdSC01NW0ZWaqP0n25eeLEFx//oa/ynZYRPu2H0d0l91397Ql7fqPs2uR0Zdat+Tuz9t0l+8q2bW8EzXHWy/zG+uv9NVM3ggHOedZ/8Syjnr+t+woT9pXtYL3/o/Oa7ywV3xVqpY53+WLN9p3L565vHmxeV8aaAWUa3483Cog1V2btu/2+Rq/aZrahsy777VvbDOrdaRl+KzrSGC6XaZvC/6fUaRlShpCb3zaDIaFtSv/2UpNB9PW9nxL2axjSE3KmUb2OX0yusN9Yv66Keobagd4dwfvDDx/nijXq8kN/wLftqdn0UtV0dykYiX68EUoS/nq5zN2lIE/8eCOUbJwNHfNSh8xPBOfhldlQsbgfb0i5cENKVBvSiLlxhJnGUeJ4lyvWuDSxxs4zWyOn3eD83ranNGnXVsYafXk5HbunhVQ460eE0OfnTvr6PNzxzPRfSnqbir++U9owTKekWyA8NqpmL+KcFD+/FKT74H18I/YRYduemrDfmbXnnZIb4U0Sj1e/9B9J5Vhj+3MmsfL+W3/GWCPPvqj3qnw6eb8t7we/WOJu3CfDNVbUNSz9k1Hy+ROauHJXJp2fyvPNXRk6YVPPxuzvA1dm7Xcm7Cs3op9KbVt13kov7n8aDs5bZfnE94egnuHxRv36iX74+MQXF7+Mrf5y88SJL058/MP/ZiufccKmksddnqeJHGJdf0b7P/l9SaeQ93N9IAuNUNv21JK6/N0l99TKGGtCqUWz31CskeLLlVn3qfksJ2ddxrsiY032TBNJtfJp7R9mOdXGt0ouH03H0jtgvk9j7bb87z84Drr1OXVahvxuEpwxytf3S3sf9v3xMTLKZ0k2/ltAqFc3Qu8j7j+VbXvKeYvfcLfy/xUlH69+qYZ2h9xXfv904pMY3isUM1ujqU/qft2f/HFI3y7btr1DKldSVdeMz0Qqqj1/pHertumfP7rzU3u+hZuWnBLt/O8DTrKRI7UfUxTnrfdUMHBueE/pyyvfH67Mhj/1yue58vUT/fviift/iIUXfazRlJenKRNV77jbtj4cqPpT3f/69yWtQt7PN7QXDeTz2T+vFJ/GvVcocLZGvggVOYHnJ+yp2WyX+eoy3pU2WzMfPwyxT0uRIxQ9P/Tl5/Xja75YE76vIfS5Xrk+p9Dn9siFh/jrS+Ois8rdXHHzRfpwIqd73QfWINZ47zJOWHQ3Tzte/Qo6RArzXsPjnx56jTUi/lJp9QlJ369z4LLEGimfxKOKNrxkvIydcP6Et/YrqD4/E8+3YIvE9ObL9T4QiSDBaaw8bx3KQUhfXvH+4H/s9oRGI/0gN2hZB5hKHveEWKOYklf2v+59KUEh7+dSDYOz16tAfBaw51iT8d4aOz5bMxGOQdkvP9VlvCtntiZE+vSTEEds1fmhK19QrAl9HurI/3DV63PTHGbN6+sOs+qTfTJdrJmfCH1KTok1acerX4lvu+6jyF0qWS5ChYrluUVBN+2fYb+dlmG2pItQmuMVuRlaRJtfjViTfL55xXL/s8jwPhD52Bqch8rz1nvZ+KiQUJ5YYx/NcS8h1hT0fq4/H4IRaiMc07NchAoXy3TNyBNpePyfQLZYU5/xrpzZmtDbk9Tp8m1WcfFYoysfWT8vfSALdr2RNrsgDz+x6TPFelfbzJxotZ+KkvcbPczZ56Nd6lizHb25ITXWJB8vtRzdE70qpIg14TFdd+uuXCacAfLdeRnu52BvGW5Vbpsi9DUo1etE/7lG3kAKuAilOX/C/RxUQ/fpKvl8axlmO9tH9rzvA1dmQxeA3AiiO2+9l1UMk/ryyveHSJyaD1+EKibWfHnxi3zfkMpzEapix92288QaXf/njTU9vp8rROqjiDXOxVPpfFbeMiyXkR/b/cWa+d5ma2o03uWLNc63uwOX7+RNNg75C2yRbKF8al5/sUP3UvL6+LX2jFdMpOkuwzSDb6zo1ruHK9th9l/Eu3woRPz7wP7rX5ZKu0Ok+3Vl/zJ5xmlCf6bUuSwtz3P+KN2P6dxTPL/uTte/s+QW9m/o8y9757oI5dU9rVykj+RmSd/Ydko535GSXj/0bMJ61bWsFHKF5F5O/mK5+7N6195141Dx0Napc8BZbxnWnT+qHSScn3by+SanvER53weuzAa3ukfm+aPnrTeLo7wFWFfetjXvD5qLVrrX78G/L5744sTFf2ffQD/nFy1W7ePuX8GxE/oz3v/bKe9LyZ2R5/1cJVwft/7+mSPfChb7OnfqF7/l/oleTlKJfMH7bf1d8KnnZ23GO37LMI5U6C5FFKVS3/fN/pE9p9R7J4fWl5uqm4UTVOqAuwZ23IFc+C3DOEIZ7wJBflX4dXzyvUGFH2b5q+BvuoxTNUdloMcdyIvZGgAAUBPM1gASxbcH+RQKAEOD2RoAAFATzNYAAICaYLYGAADUBLM1AACgJnLHmjuX/V/FF/1FwzazNQAAoDy5f8uwl2Y2r587d30zWsAm0wAAgJL0fhFq+87lSKyxma0BAADl6TnWbF6P/UEoMg0AAChRT7Fm+87lnq5AkWwAAMDg5I4123cuq24XzppsAAAABiT3LcPnVNeeMmYakg0AABicPLFm2/9yt4tvQgEAgOrgtwwDAICa4LcMAwCAmmC2BgAA1ASzNQAAoCaYrQEAADXBbA0AAKgJZmsAAEBNMFsDAABqgtkaAABQE8zWAACAmmC2BgAA1ASzNQAAoCaYrQEAADXBbA0AAKgJ8RQAAKAWiDUAAKAmiDUAAKAmRNlXwVwLi5cqu5TdNwAAIJMKxZqyq6BW2YoBAIAIUfpcSMUnRUrvlmouZR8WAAAUxKtqqOxIubB4qey+cTl5ouxavHpV4YMFAHjDiVevXj2vgMqOlAuLl8rum+fPnz9/JcWaKtSk7MMCAIACsSYFsUZZk7IPCwAACuLw8PBZBSSOlG1TmG3p507LCP1s252WITSMVqefDlpYvFR23zx79uzZ4eGhE2tKP15OTfrpUgAABkQcHh729Q3x/54Y+a+v+v+iecJI2WkZkWiijDV+Gd1j27bttimEiGybbGHxUv+t658ca6pQkxw9CADAURGHh4f/F/f7CTHx++Bxc/6reAENf7tc9COlP1WjmZExWp1MszWdliGEYZpG7lij7pyv5pteiyekzmjOfxV0XlBGhErk7x851iie/mq+GfR76AeF30/0VIVQTfo87QAAGARxcHDwJObq6ebp04oRWQghmmcfPHny5OppcfqqakPl6nS6kdKbmAlNu/Q+W2N3WvljjbqRD842m2cfSC2+etrpGqdE8+yDJ16ZSNdG1mRycHDgxBrl8Xry4Gwz6PcHZ5unrz4429QcCkWl8tckRw8CAHBUxMHBwU8R9+eazbn70bVhq+O62ZHx1eQt1XQjpSnNuSinZBJncuTZGkcvsUbd7mbTy33jq6vj46s/rY5LvXZ/rjm+qurJUKns5Fgjr78/1xTOjoJ+935wn0s6WD0cMmINAKCyxMHBweOQe3NN0Zy75zxQjIBOqdVx/6FMszpd4r01rTw5RHEvTvjJ3LEmUtV7c00xvvr43lyzOXfv8eq4GJ+ba46vPl4db87dixWNrlOUykKONeFnVsdFc251rhn0+z35h6h7c83m+Ph4L3WQa5LngAAAcEREt9v9m+T27DEhxLHZ239LdvmU7qP/qcspmyrpRkppFsZsK+ZkzHbiVI1UytFLrAnX1OkhcWp29tix2dt/u3xKnJqdPTV7+/bssVjT3bJh6Z2r0O12nVgTOV7OTo6dOnXs1KxqZ+G93Z495hyf207le+HUpN/zDgCAARDdbrcjWTl5cmXlZGPmVqdza6YRHyVPrnjl/IfhzZWr02UaKaP31KjvsTFNwzBNUz1h00usCVX01szJRkOcXFk5GfTJyZPxHlo52Zi5dWum0Zi55XSK87jjdm5ecqxRPH1rphH0+8pJEd/HrZmGEI2ZlZmG+6S7InddiDUAgMoS3W73+4iVscbMenRlrIxuZmRsJWVTpaSR0puNMVsJscYp5N6CY7Q6zs+xBNNLrJHruT4zNjMzJsZWvl+faYS6aX2mITVd7kPncbR8PnKsiT25Mib3+7qTV9bDTwcr5IqszzREuHDGmuToQQAAjorY29t7FLE81pi++ejRo2VFdBlbjpYuRtItw/L3mlSXl9qhQqF7a9qmXyq6ccZws7B4KdQ309M3l8fE2PKjm9ONxvRNr68eLY8JMbb8yH8u6ChnlVu+1/7Z29tzYk3seC2Picb0crDD5TExthyqQKx8XwfRqUmfpx0AAIOQHGsi47A/IjoPnOdvTjeEEF7JXgfvgi5CuWv7/M3CskisCVp/c7rRmJ4ec7Le8tjY9HTD6xO54/wOkR/kzxW6WBNkJv/I+JlU2ouXdfzngjCW93ARawAAldXLbI03YkZjjzts9pRsKjtSamPN8pjbHTenG8EMzfJYY3p6TJo5iQe+QmONy3lNtyZBNZ2fvNWRAxMcrlzTN8QaAEBlib29va2Ipfcbv/qL9H/pCfH+UvDjX34VvadYfjafyo6UC4uX4v0jNTT4Yel9IYQIumzp/XCHOM/32E1yrFE87R6K6AtHqhDUwBE5vHlqUvZhAQBAQRVrylDZkVIRa8qQEmuOvCZlHxYAABTE7u7uwwqo7Ei5sHip7L55+PDhw93dXSfWlH68nJqUfVgAAFAQu7u731ZAZUfKhcVLZffNt99++60ca6pQk7IPCwAACmJnZ+ebCqjsSLmweKnsvvnmm2++2dnZcWJN6cfLqUnZhwUAAAWxs7PzdQVUdqRcWLxUdt98/fXXX8uxpgo1KfuwAACgIJzBsgpL2V2hVnq3sLCwsLCwsGRcRNmxAQAAoBjEGgAAUBPEGgAAUBPEGgAAUBPEGgAAUBPaWGNZ1t/37SFdLMs6yk48AvVrEQAAhSPWDIf6tQgAgMIRa4ZD/VoEAEDhiDXDoX4tAgCgcMSa4VC/FgEAUDhizXCoX4sAACgcsWY41K9FAAAUjlgzHOrXIgAACif2XxwoF8uyPn9iD+liWZauXUO6EGsAAEiVJda03xO/+GjOFEIIId6a67jr/3rxLeF676pU8qq7/r2r9udXY1s9ab/nbSWtHFys+Z9JMXp+bXFECCHE5NrB/tqUs/eRC1tSGd/UdXnDC0mFRy5s7b/YOj8iPbs2JUYWHxJrAAAog+juv1Qu4VgjxOm2F2V+8dFf7c+fdD46ffF3ToGrphDmvF/y+MXfPfECTbCVX8DZ3P78Seej434eKj7WeA1ZmxRCjFz4bv9l9/oZJ9p09192H14YEWeueQVGzm+65a+fEdJ6qfDIwkNnpfPgZXd/c2FETF5/2b1+xn39/ZfXJsXkdXV/9rkQawAASJUUa2799PrWT69v/fTpe2L0o/vO4+8/Ou4/fv3bX496MxcfzEdLqh6vfiDC3vr1995eilzCscYPIqrHUigJhZVogvEKh42c35RKrk26kYhYAwBACXqNNfc/ecsPJfc/eSt7rDn+yW8HkGMKjTXKiRllYXf57vzIyPnN786PuLM7xBoAAMog9rovlItlWeuPX68/fr3++NN3xeiH95zH3394fPTDe6/XVz8Qxz/5zePX649f/+bXo0J8cDZaUvn403eFeHfVWfn67LizVfGLZVleQ9YmxcjCdwmP1yaFGFnYdMtfOyNGLnwbLby5MBIUnrzmdtG1yTPXnK2+uzAycmZyxC9f/EKsAQAgVa+x5vH3Hx73LiSNf/BW1ljzev3eJ/6Nxn6+KTXWuGHF4yUVdax5sffdhRGvqJ9v9rovrk0KLw8RawAAKIfY3dtXLpZlffafn4d0sSxL164BLX+aFM2Fh4N7fWINAACpxM5uV7lYlvXZP38e0sWyLF27BrJ8s9AUk38c5C6INQAApEqKNTf/9WpIl6OMNX/8pRBC/PJPg90LsQYAgFTi+c6ecrEs6+Y/Xg3pYlmWrl1DuhBrAABIJZ4931UulmX9eftwSBfLsnTtGtKFWAMAQCpizXAsxBoAAFIJC0Oi7FMFAICqE7onhnocffr0adlVKFj9WgQAQOGINcOhfi0CAKBwxJrhUL8WAQBQOGLNcKhfiwAAKByxZjjUr0UAABQuQ6zptAxhtDrZX7PTMoTZ7rNifalfCKhfiwAAKFz9Y03bDP48t9QOf7WiaT1sMmjEGgAAUg3iIlTlYk0shkhJrW2KWGV72GTQiDUAAKQS+y8OlEudY02ogora9rDJoBFrAABIlSHWyIN4p2V4F2ekcT24aGO0OqENnPJHnnE0F6G8erTNSO2NVic6HZNlkyNErAEAIJXo7r9ULqpY02mZ3mAeXIhpm9GbTbwN4s8cFWUI8HNLZLIlHmuybnKEiDUAAKTKFWu8n+SZDN0FG7OEG1B8mhDg1TXH1EsPmwwEsQYAgFR5Yk2nZfjTL/5KTawRhpHz+1NFSo81QdWSb5TpYZOBINYAAJBK7HVfKBdFrJGG9k7LkC9C+XegtOQrNlKhIyaFgLYp3R4TC2XKWNbDJgNHrAEAIFWeWCNdgDJMU3UfcVBMDgYlfx1a+etmonVW1Tp1kyNErAEAIJXY3dtXLrp7a4ZCLyEgfPdM1RBrAABIJXZ2u8rFjzW5f8lwBfQQAqqdaog1AACkS4w17rWYKg/3avULAfVrEQAAhRPPd/aUC3/Bu1Lq1yIAAAonnj3fVS7EmkqpX4sAACgcsWY41K9FAAAUTlh6T1ElZZ8qAABUndA9wWxNpdSvRQAAFI5YMxzq1yIAAApHrBkO9WsRAACFI9YMh/q1CACAwhFrhkP9WgQAQOGyxJqK/10BhfqFgPq1CACAwr0xsabTMkJ/kFv5R7ol/vNB2wewST8tAgAAYW9IrOm0DMMI/mSn9Oc726bij161zVgOGcAmfbUIAABEif0XB8qlTrGm0zKMVicIHp2WEbQo9INUPPyKxW/SV4sAAEBc3lgTXGhRXdDp+1pLQUIhwIscQawJ5zR3vT+30mkZRqsVuXpU1CaFtAgAAKiI7v5L5aKKNfLQ7E8/KFeWTAoBQZX8ikZqGc0obTO4O8ZbWdgmBbQIAACo5Yk1waSMNC2hXFk2PwTI2SJltkbzs/tT4Zv02iIAAKCTM9bER+Y+h+vB8EJAp2WIKLMdrnNshil8n0yQUYrdpMcWAQAALbHXfaFcNBeh5LtsElaWTBkCpJghhYzkbzAFDwvfpIAWAQAAWa5YE5r+CPKLcmWp0mKNXGe5aYo7o1XN7GOTQlsEAABkYndvX7m8cX88oYevsR/hN9+JNQAApBI7u13l8qbFmmqnGmINAADpiDXDoX4tAgCgcOL5zp5yIdZUSv1aBABA4cSz57vKhVhTKfVrEQAAhSPWDIf6tQgAgMIJS+8pqqTsUwUAgKoTf9+3lYtlWS+H1tOnT8uuQsGINQAApCLWDAdiDQAAqYg1w4FYAwBAKmLNcCDWAACQilgzHIg1AACkEkKokw2xplKINQAApHL/wHStY83alNvKqTXFytHFrdj2W4ujIr5N4iY97CVni8o+VQAAqDrh08earcXR0FhdfVKs2Vocdeu+NuVHjq3FUS9oSGs9a1N+CAmanrxJD3vJ3aKyTxUAAKpOyD5/YvtLXWKNZG3KTRmhBiW3bmtxdHRxK88mvewlHbEGAIBUIiIWa/zLKEKeeYhdolmbEqOLa+61m6m1oFS/V196DQHxlX7eeLk2Fbm2NLq4Jc+thDeaWsuzScpe+mhR2acKAABVF401frLRzNasTclJJbi2sjblRxgn0ASXbkqY6AnFmi0pbPkrcmaU9E0y7qWPFpV9qgAAUHXRTHPrp9fOoo410cHZf0p+Qvf46Ohma4LglSFwhO6HyTz1kncvGRFrAABIpc40eWKNP4ZXPdYElQlVSj2hFL3HN8MmPewlO2INAACpgkyz/vi1vGS9CBXcSFLJWBN8RUm+ZJQQ1MIFwyu1m/Syl9wtKvtUAQCg6tSZJhxrvPtGUm8ZrmCs0f0OmmCtnEe862kh0btnFJtk30sfLSr7VAEAoOqEEOKz//wcX2r06/iyCd8KM6hNekWsAQAglfjsnz8rlzct1lQ71RBrAABIJ27+65VyedNiTcURawAASCVu/uOVciHWVAqxBgCAVOLP24fKhVhTKcQaAABSEWuGA7EGAIBUwtJ7iiop+1QBAKDqRNkVAAAAKAaxBgAA1ASxBgAA1ASxBgAA1ASxBgAA1ASxBgAA1ASxBgAA1MT/A3ZmQIVXFGlrAAAAAElFTkSuQmCC" alt="" />

  以name分组,去掉冗余的money,用';'分隔

    select aa.`name`name , GROUP_CONCAT(DISTINCT money separator ';') money from aa GROUP BY aa.`name`

    aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAA2AAAACqCAIAAABEa7u8AAAaKElEQVR4nO3dy2/c1qHH8fP3ZDeGR1C5irfNxqvI3siqrBDJLttK0CqyrmUL8Wy8kCADbReG3NvW1jUyrSPHCGAvYtdKkMQSjAwDFOlthdZRrx96+JGYd8HXOeTha2YoPvz9gLBnOIecw8PXbw45I2EDAAAAElF2BQAAAFAtBEQAAAAoxMsC2Lad5V8AAAAkEKKcvrxCAiLpEAAAYHCNCog2PYgAAAADa1RAJB0CAAAMrn4BcfPa2bNnz166vd1HOuw7I/5w3X57wn57wp66PqwWOHS9jiHM7pvzvkPSMYTL6HRNo9Oz7a4pZEZHLh+86I33xxidXs+fndFRZu4VSK2PPP9ex/BbNu59nXmG3jdmPtKCSQvVC9UypqYdwxu5bU9NuPvL2xP2sQn7jlfmzlIw/u0J+9hSMPnl2WDk/KxtSzudPKvL27HzcUY6e6g/7bHZ8Fsfm7V/uG7PbyTNHxX2xebx459/+IeByvc6hrrb1pG8F8xvlF2bnIL9fda+s2Rf3rbtDXVnnFXKy/tvaMzU9fD+7s88y1k7dBzwDwLOeP+pM0/5kFWsapyvaxYQt29fOntt8+XmNW1ALCgd+n64PoSAeHk2OF8etq6ZLYQ05X0H1jWDevc6hr8UvSANKWW6pvB3rl7HkNKYvPhdMzg5dU1pb5TmGlsfZf7es4T3NQzpBTkd6ubjF5Mr7C+sX1dNPZXlsO0N6Ui6oWREW7cfyWPuLLlHeX/knSX3/Hd5Vglw0fncWbKn/P1r256SziV+fZzjvhMQk+ePPhzC8e1vH+YKiPryoQ22fqTNu3buLAV77g/XlUwmHweUY4K0/8oZUd5h56UGmZeOOan7tfOJ0bUhZdMN6QizcYjp0FGB83XNAqIrJiDaeXoQ5U8wwZ4mdX4ci+x+moAYX17+xONuoGrPSqaPfUqfTi99fB5uMjD9WUkHzOj8ndKGYTol3QJqytD1qEW5Z+il4BNbcEbZiHzs27anJuxjs/a8U3JDnSRxfQ0qvptBDoi2348XKe+fhDIGRLlHUP+u2peT37fjPfGLJb6N+6JaY01dVeFPu+rBNLTjJAfEKD/AhWgD4uXr3lv7Z9BteyrxyB43f0Xy9q90Brsjk/Yv7f7ijlR2uNS9Kftx7PKsfWzCvnw93FNi27r9Tpq530MT7Hfa8onHt6Ce6plbP/9Ef/vw+OcXvoiM/mLz+PHPj3/4t//NVj5jJ2Il13u4B11axXHtGW7/5ONqnKGcj+KjrbJH+7ttpLy/w2YMiEr+i3lfJSCqVzacl+azbJyNO1+LJgXE7OlQ22Nhqx815E8q0amSy4c/8UjH4nyfsLtd+UgUbBFx43PqdQz5uBZsu9r5+6W9Dig/aYTyUpaM6B+MlFbdUI5o7k67bU85JxuvL8rfn5PX16B0Ickht5XfPr1ox5o3h+H0IMbUJ/V93Wf+GTF+uWzb9lapXEldXZNfCX3aTsyLDjnohOQLiNveacM/r2ykdPxnCoh28vYvHfe7pr/9x+1fsfuLumqSPy/Y+Y9jTkaUP1z5gU+z33kvBStlw3spvrz2+HZ5Vu2JkVexdv6J/n3h+L0/RGJgfECMKS93/Seq3nq37fiYpWtPffvHH1djDeV8FL8/ytuzv11pDhcbQd//sHoQtbfE+LOams12iGjc+bpRAdHO04M4H90gIp+AUy6NxZefj08q+QKiev+X0tekHZ+T0pcUuqwYnb+UMJxR7uSam9TST2zyJ7a4ToggIHrHOydnuJOnra9BBQ0ifUDzFjz6ibDfgCiis0qrjyL9fZ0VlyUgSkkvGgdjA2L0dpn8AVF+NdoZnysguhtMEQExbvtXl95vYP3+lbi/BFMk5nhfruNYKMwFu6F2v3NoWy++vOb4FunBVc7raWunOFlP1ZVc7wkBUXOZS9v+ccfVBEM5H0k1DLZerwLRnum+A2LGexDtaA9i6F7k7BeXG3e+Fk0KiNnToUL6RJsQ7GzdlhpXfkgBUfmM25MPIfrxucVscDHzj9vgdL1NyeIC4vyE0vOREhDT1tegEk8A7qPQ3XxZLjErxfLcChV3USzD+/Y6htmRLjHHrK/Q129EePH7DIipl5hDQldzcgdEZwu5Ll1iTtxODjsgJu8vXrHcu3WG41j0Jk7/8plmv/NmG11ZCeUJiPbhrPcSAuKQzkfx20OwR2+oH3iyXGJWi2W6IuwJLXh0F8gWEBt4vm5UQLQz9yAqB0pp9cs3xkbpb4rXlQ+Nn5c+ZAdvHbl5P0w+kUc6lzXjXV0z86eU2E+6ye8b3uCyX61x6QPidvgmqtSAmLy+9HI0T/iaryYgquko7ssichk1TeW7V15t5+DdMnw5pmsK5SvMuvmEDxyhQ1nfl5jn076kIgcO7fkjb0B05inf8hG3PybMPyx++1e3k6AZ4z7xJ+8vHcPsZutGynscuzyr9M66YS5uv/Nmqwkc8eW1x7dQMFXy67AC4hcXPs/37eY8l5grtt5tO09AjGv/vAGxz/ORRqg+moDoXEmQtmftl1TkMvJje7CAON9fD2ITz9c1C4jOb9wELt3OmxEd8tfgQylN+9J8/KXMuFnJ46P39GS8Hip1BhumGXzbNG68bdvZNzh/Jt5tCkJEfxXFn/8lqbQbNtwfbfFvx8nYie5fR3Buf5GvAvwg3UHvfItlft29mHVsyS3s34Lt316T6xKzV/e0cqE2khdL+t0ap5Tz/WZp/sqrCeN1V6pTyBWSWzn553Xc5/q39u5PUYorU6deIVFCb/yXFeJ+5mZe3bnk3intyk34mZvgitJGOAxF65N875Gil7j96xooYf+yk/cXOe8nynscuzwbfDksdBUvvN95PYva9RhX3ml2TX1iLknHzb8P/75w/PPjF/6dfYL4fvRwsWqv97j9SGnPaPtvpxxXkxsjz/lIJ/RLWE79/S1HvmVW9zNVMu14+Rs5qb9LEP25q5RbnuI173wt6hUQk9n8JRWkUe4rx7DU/ldDqiR7N1JOzf0dny82dV9PSVDFDbaw9Q70p1EBkXSIFNG75TAkqT/iiFTyPaBD30wTvif+xsnYfXhYCl3vQN8aFRBtehABAAAG1qiASDpE7Wl+g4CeBQDAYWtUQLTpQQQAAKgtehABAACgoAcRAAAACnoQAQAAoOg/IN6+5P9IdviPqdj0IAIAANRW/39JxcuFm9fOnr22GS5gkw4BAADqaQiXmLdvXwoFRJseRAAAgNoaPCBuXov8IWbSIQAAQH0NFhC3b1/q6/oyGREAAKCy+g+I27cv6b6gkjUjAgAAoJr6/5LKWd2V5YzpkIwIAABQWX0FxG3/J25cfIsZAACgMfhLKgAAAFDwl1QAAACgoAcRAAAACnoQAQAAoKAHEQAAAAp6EAEAAKCgBxEAAAAKehABAACgoAcRAAAACnoQAQAAoKAHEQAAAAp6EAEAAKCgBxEAAAAKehABAACgEI8BAAAACQERAAAACgIiAAAAFKLsa9xhC4sXKzuU3TYAAACHoYoBsewq6FW2YgAAAMPlBsTSO+eq31FXerNUcyh7tQAAgOELAuJP1VDZzFGpJqpIZSq7sgAAwCCUgPi0AiqbORYWL5bdNk+fPn36kxQQq1CTslcLAAAYPgJiVgREbU3KXi0AAGD4goD46tWrJxWQmDm6pjC70vNex1Ce23avY4gYRqc3SEstLF4su22ePHny5NWrV05ALH19OTUZpEkBAEA1KQFxoB/M+e+Jkf/6cvDf3UnIHL2OEQp52oDol4l7bNu23TWFEKFpky0sXhx86QYnB8Qq1CRHCwIAgJpQAuL/Rf1+Qkz8Pnjcnv8yWiCGP10u8ZnD7z6M6SU0Or1MPYi9jiGEYZpG7oCob5wv59veEk9IjdGe/zJovKCMUErkbx85IGpe/nK+HbS78kTj9xN9VUGpyQDbHgAAqKggIL58+XIn4sqp9qlTmmwjhBDtM/d3dnaunBKnrugm1I5OF5c5vM5CpSuw/x5Eu9fJHxD1C3n/TLt95r60xFdOOU3jlGifub/jlQk1bWhMJi9fvnQConZ97dw/0w7a/f6Z9qkr98+0Y1aFplL5a5KjBQEAQE0oAfHHkHtz7fbcvfBY1ep4XI/d+GrylHpxmcOU+gG13YSJvYtyD6Kjn4CoX+5220vQ46ur4+OrP66OS612b649vqprSaVUdnJAlMffm2sL542CdveeuK8lraw+VhkBEQCAplIC4iPF3bm2aM/ddR5osoRTanXcfyiLGZ0u8R7ETp5Ep7lnUX0xd0AMVfXuXFuMrz66O9duz919tDouxufm2uOrj1bH23N3I0XD4zSlspADovrK6rhoz63OtYN2vys/Cbs7126Pj4/3Uwe5JnlWCAAAqIcgIO7v738vuTV7RAhxZPbW98kunYzrjjp5KWVSrbjMIfUMml1NP6HZTew+lEo5+gmIak2dFhInZ2ePHJm99f2lk+Lk7OzJ2Vu3Zo9EFt0tq0pvXI39/X0nIIbWl/MmR06ePHJyVvdm6rvdmj3irJ9bTuX74dRkkI0PAABUkxIQe5KVEydWVk60Zm72ejdnWtG8cWLFK+c/VCfXjk6XKXOE7z3U34tomoZhmqa+E7GfgKhU9ObMiVZLnFhZORG0yYkT0RZaOdGauXlzptWauek0ivO45zZuXnJA1Lx8c6YVtPvKCRF9j5szLSFaMyszLfdFd0TuuhAQAQBoKiUgfheyMtaaWQ+PjJSJ660bW0mZVCspc3g9hGYnISA6hdxbFY1Oz3keyYL9BES5nuszYzMzY2Js5bv1mZbSTOszLWnR5TZ0HofL5yMHxMiLK2Nyu687yW9dfTkYIVdkfaYl1MIZa5KjBQEAQE0EAXFvb+9hyPJYa/rGw4cPlzUhcGw5XHo4kr6kIn8nWXfxuKsUUu5B7Jp+qfDEGWPiwuJFpW2mp28sj4mx5Yc3plut6RteWz1cHhNibPmh/1rQUM4ot3y/7bO3t+cExMj6Wh4Trenl4A2Xx8TYslKBSPmBVqJTkwG2PQAAUFEZA2Io0fjZwnngvH5juiWE8Er2G4OGdInZHTvgX0+RhQJisPQ3plut6ekxJzUvj41NT7e8NpEbzm8Q+UH+hBYXEIP06a8ZP91L7+KlRv+1INbmXV0ERAAAmmqgHkQve4QDpBtA+sqIlc0csQFxecxtjhvTraDXcHmsNT09JvXmRaPzUAOiy5mnW5Ogms4zb3RoxQSrK1eXIgERAICmUgLiVsjSu61f/0X6X3pBvLsUPP3Lr8PfYpFfzaeymWNh8WK0faQFDZ4svSuEEEGTLb2rNojzep/NJAdEzcvuqgjPOFSFoAaO0OrNU5OyVwsAABi+xIBYhspmDk1ALENKQDz0mpS9WgAAwPAFAXF3d/dBBVQ2cywsXiy7bR48ePBgd3fXCYilry+nJmWvFgAAMHxKQPymAiqbORYWL5bdNt988803ckCsQk3KXi0AAGD4goD47NmzryugspljYfFi2W3z9ddff/3s2TMnIJa+vpyalL1aAADA8CkB8asKqGzmWFi8WHbbfPXVV1/JAbEKNSl7tQAAgOETTtqo1FB2m+iV3iwMDAwMDAwMDIcziLJzFwAAAKqFgAgAAAAFAREAAAAKAiIAAAAUBEQAAAAo0gOiZVl/P7BrOliWdQiNeJiat0QAAKBqCIg107wlAgAAVUNArJnmLREAAKgaAmLNNG+JAABA1RAQa6Z5SwQAAKqGgFgzzVsiAABQNQTEmmneEgEAgKohINZM85YIAABUjTh4/jJ5sCzrsx27poNlWakLWK+BgAgAAIqWKyB23xG/+GDOFEIIId6a67nj/3rhLeF654pU8oo7/p0r9mdXIlPtdN/xppJGFhcQ/2dSjJ5bWxwRQggxufbyYG3KefeR81tSGd/UNXnC80mFR85vHTzfOjcivbo2JUYWHxAQAQBADYn9gxfJgxoQhTjV9ULhLz74q/3ZTu+DUxd+5xS4Ygphzvslj1743Y4XDYOp/ALO5PZnO70PjvrJcvgB0VuQtUkhxMj5bw9e7F877YTE/YMX+w/Oj4jTV70CI+c23fLXTgtpvFR4ZOGBM9J58GL/YHNhRExee7F/7bQ7/4MXVyfF5LWUhu1vICACAICiZQqIN398ffPH1zd//OQdMfrBPefxdx8c9R+//u1Ho15v2nvz4ZK6x6vvCdVbH33nvcswBzUg+pFO91iKd0rsC2dBr7Bq5NymVHJt0g2XBEQAAFA/AwfEex+/5ce7ex+/lT0gHv34twUkwqEGRG1nobawO3x7bmTk3Oa350bcHkcCIgAAqCGxt/88ebAsa/3R6/VHr9cfffJLMfr+Xefxd+8fHX3/7uv11ffE0Y9/8+j1+qPXv/loVIj3zoRLah9/8kshfrnqjHx9ZtyZaviDZVnegqxNipGFbxMer00KMbKw6Za/elqMnP8mXHhzYSQoPHnVbaKrk6evOlN9e35k5PTkiF9++AMBEQAAFG3ggPjou/ePepeJx997K2tAfL1+92P/qy1+Uiw1ILqxz+NlPn1AfL737fkRr6ifFPf2n1+dFF6yJCACAIBaErt7B8mDZVmf/ufnmg6WZaUu4HCHP02K9sKD4uZPQAQAAEUTz3b3kwfLsj795881HSzLSl3AYQ5fL7TF5B+LfAsCIgAAKFqmgHjjXz/VdDjMgPjHXwkhxK/+VOy7EBABAEDRxNNne8mDZVk3/vFTTQfLslIXsF4DAREAABRNPHm6mzxYlvXn7Vc1HSzLSl3Aeg0ERAAAUDQCYs0GAiIAACiasFA3ZW8zAACg4cTfD+zkodaJ5PHjx2VXYciat0QAAKBqCIg107wlAgAAVUNArJnmLREAAKgaAmLNNG+JAABA1RAQa6Z5SwQAAKomCIhC6MNiEBB7HUMYnV72mfc6hjC7hdQ7o+bFqeYtEQAAqBolIGozYmMCYtcUgWA5/NG5Fq00BEQAAFC0cECMZsQBLjFXLiBGMqCUebumKLmymRAQAQBA0cRnO7YzSN1rwcjPdhodEJUKll/bLAiIAACgaPqAKGdE9RKzl6B6HcMrKYWq4Cqu0ekpEzjlDz1/xVxi9urRNUO1r/5lZgIiAAAoWmxA9DOiLiD2OqaXpIIrs10zfB+fN0H0lcOijVP+deVQnyEBEQAAwLZtcfPH184QSof+eH0PYrQPMe4KrlnmvX0xccqrKz2IAAAAEfqA6I/UB8Rex/C7BP2RMQFRGEbO7z4PU3pADKrGPYgAAAC2bdti/dFrZ/DToT/GGTQBUcpVvY4hX2L2b+7ryJdwpUKHTIpTXVO68zASb2vSf0hABAAAxQsHxFA61AdE6fKyYZq6b64ExeRUdvgpUYlT2l88DNe56giIAACgaOLT//zsDEIEj+Uh7h7EWmhenGreEgEAgKoRn/7z5+TBD4i5/5BKBTQvTjVviQAAQNWIG//6KXmwLMu7OFuz7kO7iXGqeUsEAACqRtz4x0/JwwB/SaV8zYtTzVsiAABQNeLP26+SBwJipTRviQAAQNUQEGumeUsEAACqRlgZPEaVlL3NAACAhhOpJehBrJTmLREAAKgaAmLNNG+JAABA1RAQa6Z5SwQAAKqGgFgzzVsiAABQNQTEmmneEgEAgKrJFRC7Zt3+mErz4lTzlggAAFTNmxcQex1DyH9T2v0zgiLu70z7rwfLnjZJkQiIAACgaG9aQOx1DMMw/GTX6/iPu6bmj013zUgITJukYAREAABQNHHw/GXy0KSA2OsYRqcXpL5exwiWSHkiFVfnmDJJ4QiIAACgaH0HxODKq+5ybRkXX3WUOOXlvSAgqonXHe93EfY6htHphC4nayc5RAREAABQNLF/8CJ50AVEORf5vWjakSWT4lRQJb+ioVqGA2LXDG489EbqJzlEBEQAAFC0vgJi0FEo9a5pR5bNj1NysEvpQYx57j6jBxEAADRdvwExGosOPytl4MWpXscQYWZXrXOk11O9BTEIiAmTFI+ACAAAiib29p8nDzGXmOW7ERNGlkwbp6SMJyW85C8sBw+TJykcAREAABStv4CodMkFSVA7slRpAVGus7xomu/i6BazhKUkIAIAgKKJ3b2D5OGN+1N71f4xHwIiAAAomni2u588vGkBsdr5kIAIAAAKR0CsmeYtEQAAqBrx9Nle8kBArJTmLREAAKga8eTpbvJAQKyU5i0RAACoGgJizTRviQAAQNUIK4PHqJKytxkAANBwIrWEZVkvauvx48dlV2HICIgAAKBoBMSaISACAICiERBrhoAIAACKRkCsGQIiAAAoGgGxZgiIAACgaATEmiEgAgCAor1RAXFtSjim1jQjRxe3ItNvLY6K6DSJkxSMgAgAAIqWKyBuLY4q2ar6pIC4tTjq1n1tyo97W4ujXsqTxnrWpvwEGCx68iSFIyACAICiiYPnL5OHpgREydqUG/GUBUpeuq3F0dHFrVyTFIKACAAAipY9IPrXVYXcgRa5ALs2JUYX19wrs1NrQakSLsfGBEQ/H75YmwpdOR5d3JK7CNWJptbiJjlEBEQAAFA0sX/wInmI6UFcm5IzX3CxdW3KD4NONAwuzJbQ+agExC0ptvojsgVEfZ8jAREAADRRvwExnIz8l+QX4h4fnrgexCDCZkh7yq2G9CACAICmG2JA9DNX1QNiUBmlUvpOzvAXUTJMUigCIgAAKJrY23+ePGS9xBzc1lfJgBh8iVm+hpwQedWC6sj4SQpHQAQAAEXLFRC9u/hSv6RSwYAY95uGwVg5P3pXyxVe/aOTHCICIgAAKJrY3TtIHhr0Q9nZqHcZVg0BEQAAFE08291PHt60gFjtfEhABAAAhSMg1gwBEQAAFE08fbaXPBAQK4WACAAAiiaePN1NHgiIlUJABAAARSMg1gwBEQAAFE1YGTxGlZS9zQAAgIYTZVcAAAAA1UJABAAAgIKACAAAAAUBEQAAAIr/BxNz4XgrPoKxAAAAAElFTkSuQmCC" alt="" />

       参数设置与限制说明
    1.查看服务器中设置

      mysql> show variables like '%group_concat%';
      +----------------------+-------+
      | Variable_name | Value |
      +----------------------+-------+
      | group_concat_max_len | 1024 |
      +----------------------+-------+
      1 row in set (0.00 sec)

    以上设置的值说明当前是默认长度1KB

   2.改变参数值

    方法一:修改配置文件中参数,新增 group_concat_max_len = 10240

    方法二:在会话中实现,全局或当前session中

    SET GLOBAL group_concat_max_len=10240;

    SET SESSION group_concat_max_len=10240;

最新文章

  1. STM32F412应用开发笔记之二:基本GPIO控制
  2. npm 安装远程包(github的)
  3. C++之虚函数和多态
  4. RabbitMQ的work queue(2)
  5. POJ 1741 Tree (树的点分治入门)
  6. hdu 1698 线段树 区间修改
  7. register_globals
  8. muParser公式库使用简介( 转)
  9. 实现一个JavaScript模块化加载器
  10. IOS 判断设备屏幕尺寸、分辨率
  11. css行高line-height的用法(转)
  12. mpi中利用自定义归约操作实现merge
  13. 关于项目刚才还能运行的,重启Myeclipse就不能运行(报错)的解决方法
  14. php上传zip文件在线解压文件在指定目录下,CI框架版本
  15. 在AWS中部署OpenShift平台
  16. SpringMVC注解控制器详解
  17. Asp.Net Core 轻松学-一行代码搞定文件上传
  18. splay详解(一)
  19. Java基于opencv实现图像数字识别(二)—基本流程
  20. 解决vue-cli不能初始化webpack模板的问题(vue init卡住了,解决办法)

热门文章

  1. LINUX监控一:监控命令
  2. ZOJ 3686 A Simple Tree Problem(线段树)
  3. 【转】cpu的核心数与线程数的关系
  4. PHPCMS调取当前栏目的描述、文章位置导航、当前栏目链接、当前栏目名称
  5. freefcw/hustoj Install Guide
  6. javaIO--文件操作类
  7. iOS- <项目笔记> UIApplication常见属性与方法总结
  8. JS高级 1
  9. C# Find()和First()与FirstOrDefault(
  10. 关于已部署的WCF服务升级的问题