{"id":9529,"date":"2022-12-25T15:31:02","date_gmt":"2022-12-25T10:01:02","guid":{"rendered":"https:\/\/selfimagination.in\/tips\/?p=9529"},"modified":"2022-12-25T15:31:05","modified_gmt":"2022-12-25T10:01:05","slug":"group_concat-in-mysql","status":"publish","type":"post","link":"https:\/\/selfimagination.in\/tips\/group_concat-in-mysql\/","title":{"rendered":"GROUP_CONCAT in MySQL"},"content":{"rendered":"\n<p>Group_concat in sql, how to merge string in mysql, string aggregation, How to order Group concat in SQL?<\/p>\n\n\n\n<p>\u091c\u092c \u092d\u0940 \u0939\u092e \u090f\u0915 \u0938\u0947 \u0905\u0927\u093f\u0915 Rows \u0915\u0940 String Value \u0915\u094b \u091c\u094b\u095c\u0928\u093e \u0939\u094b \u0924\u092c \u0939\u092e Group_Concat \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964 \u090f\u0915 \u0924\u0930\u0939 \u0938\u0947 \u0939\u092e \u0907\u0938\u0947 Aggregate Function \u092d\u0940 \u0915\u0939 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0915\u094d\u092f\u0941\u0915\u0940 \u092f\u0939 Rows \u0915\u094b Group \u0915\u0930\u0928\u0947 ka \u0915\u093e\u0930\u094d\u092f \u0924\u094b \u0915\u0930\u0924\u093e \u0939\u0940 \u0939\u0948\u0902 \u0915\u0947\u0935\u0932 \u092f\u0939 Calculation (Count, Sum, Avg, Min, Max) \u0915\u0947 \u0938\u094d\u0925\u093e\u0928 \u092a\u0930 Concat \u0939\u0940 \u0915\u0930\u0924\u093e \u0939\u0948\u0902 \u0964<\/p>\n\n\n\n<div class=\"wp-block-rank-math-toc-block\" id=\"rank-math-toc\"><h2>Table of Contents<\/h2><nav><ul><li><a href=\"#1-group-concat-without-any-options-simple\">1. GROUP_CONCAT Without any Options (Simple)<\/a><\/li><li><a href=\"#2-group-concat-with-distinct\">2. GROUP_CONCAT With DISTINCT<\/a><\/li><li><a href=\"#3-group-concat-with-order-by\">3. GROUP_CONCAT With ORDER BY<\/a><\/li><li><a href=\"#4-group-concat-with-separator\">4. GROUP_CONCAT With SEPARATOR<\/a><\/li><\/ul><\/nav><\/div>\n\n\n\n<p>\u0906\u092a \u0928\u093f\u092e\u094d\u0928 Image \u0938\u0947 \u0938\u092e\u091d \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0915\u0940 Group Concat \u0915\u093f\u0938 \u092a\u094d\u0930\u0915\u093e\u0930 \u0938\u0947 \u0915\u093e\u0930\u094d\u092f \u0915\u0930\u0924\u093e \u0939\u0948\u0902 \u0964<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"340\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-23.png?resize=640%2C340&#038;ssl=1\" alt=\"group_concat with all options\" class=\"wp-image-9832\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-23.png?w=955&amp;ssl=1 955w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-23.png?resize=300%2C159&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-23.png?resize=768%2C408&amp;ssl=1 768w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-23.png?resize=140%2C73&amp;ssl=1 140w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-23.png?resize=60%2C31&amp;ssl=1 60w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-23.png?resize=150%2C80&amp;ssl=1 150w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n\n\n\n<p>   <\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"example-data-for-group-concat\">Example Data for Group Concat<\/h2>\n\n\n\n<p>Example \u0915\u0947 \u0932\u093f\u090f \u0939\u092e\u0928\u0947 \u090f\u0915 Table \u091c\u093f\u0938\u0915\u093e \u0928\u093e\u092e citemmst \u0939\u0948\u0902 \u0909\u0938\u092e\u0947 Customer Name (cust_nm) \u0914\u0930 Item Name (item_nm) Columns \u0939\u0948\u0902, \u0905\u092c \u0939\u092e Group Concat \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0938\u0940\u0916\u0947\u0902\u0917\u0947 \u0915\u0908 \u0915\u093f\u0938 \u0924\u0930\u0939 \u0938\u0947 \u0939\u092e \u090f\u0915 Customer \u0938\u0947 Related data \u0915\u094b Merge \u0915\u0930 \u090f\u0915 \u0939\u0940 Column \u092e\u0947 \u0932\u093e \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"179\" height=\"310\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-17.png?resize=179%2C310&#038;ssl=1\" alt=\"\" class=\"wp-image-9821\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-17.png?w=179&amp;ssl=1 179w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-17.png?resize=173%2C300&amp;ssl=1 173w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-17.png?resize=150%2C260&amp;ssl=1 150w\" sizes=\"auto, (max-width: 179px) 100vw, 179px\" \/><\/figure>\n<\/div>\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"1-group-concat-without-any-options-simple\">1. GROUP_CONCAT Without any Options (Simple)<\/h2>\n\n\n\n<p>\u092f\u0939 \u092a\u0930 \u0939\u092e\u0928\u0947 \u0915\u0947\u0935\u0932 GROUP CONCAT \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u093f\u092f\u093e \u0939\u0948\u0902, \u0907\u0938\u0915\u093e \u0909\u092a\u092f\u094b\u0917 Group By \u0915\u0947 \u0938\u093e\u0925 \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902\u0964 \u0939\u092e\u0947 \u090f\u0915 Customer \u0915\u0947 Data \u0915\u094b Merge \u0915\u0930\u0928\u093e \u0939\u0948\u0902 \u0907\u0938\u0932\u093f\u090f \u0939\u092e\u0928\u0947 GROUP BY cust_nm \u092a\u0930 \u0915\u093f\u092f\u093e \u0939\u0948\u0902  \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\">SELECT cust_nm, GROUP_CONCAT(item_nm)\r\nFROM citemmst\r\nGROUP BY cust_nm<\/code><\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"317\" height=\"104\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-18.png?resize=317%2C104&#038;ssl=1\" alt=\"group_concat without option\" class=\"wp-image-9822\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-18.png?w=317&amp;ssl=1 317w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-18.png?resize=300%2C98&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-18.png?resize=150%2C49&amp;ssl=1 150w\" sizes=\"auto, (max-width: 317px) 100vw, 317px\" \/><\/figure>\n<\/div>\n\n\n<p>\u0905\u092c \u0915\u0947\u0935\u0932 3 Customers  \u0915\u0947 \u0915\u0947\u0935\u0932 3 \u0939\u0940 Records \u0906 \u0930\u0939\u0947 \u0939\u0948\u0902 \u091c\u092c\u0915\u093f \u092a\u0939\u0932\u0947 10 Records \u0925\u0947 \u0964 Item \u0935\u093e\u0932\u093e Column Merge \u0939\u094b \u0915\u0930 \u090f\u0915 \u0939\u0940 Row \u092e\u0947 \u0909\u0938\u0915\u0940 \u0935\u0948\u0932\u094d\u092f\u0942 \u091c\u0941\u095c \u0917\u0908 \u0939\u0948\u0902\u0964 <\/p>\n\n\n\n<p><a href=\"https:\/\/youtu.be\/-oK36np3D8Q\" target=\"_blank\" rel=\"noopener\">Related Video : Group_Concat in MySQL<\/a> <\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"2-group-concat-with-distinct\">2. GROUP_CONCAT With DISTINCT<\/h2>\n\n\n\n<p>\u091c\u092c \u092d\u0940 \u0939\u092e\u0947 Duplicate Remove \u0915\u0930\u0928\u093e \u0939\u094b \u0924\u092c \u0939\u092e GROUP CONCAT \u0915\u0947 \u0938\u093e\u0925 DISTINCT \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902\u0964 \u0910\u0938\u093e \u0915\u0930\u0928\u0947 \u0938\u0947 \u091c\u094b \u092d\u0940 Duplicate Data \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0935\u0939 Remove \u0939\u094b \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT cust_nm, GROUP_CONCAT(DISTINCT item_nm )<br>from citemmst<br>group by cust_nm<\/code><\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"334\" height=\"104\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-21.png?resize=334%2C104&#038;ssl=1\" alt=\"group_concat with Distinct\" class=\"wp-image-9830\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-21.png?w=334&amp;ssl=1 334w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-21.png?resize=300%2C93&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-21.png?resize=150%2C47&amp;ssl=1 150w\" sizes=\"auto, (max-width: 334px) 100vw, 334px\" \/><\/figure>\n<\/div>\n\n\n<p>\u0909\u092a\u0930\u094b\u0915\u094d\u0924 Example \u092e\u0947 \u0906\u092a\u0928\u0947 \u0926\u0947\u0916\u093e \u0939\u094b\u0917\u093e \u091c\u094b \u092a\u0939\u0932\u0947 Duplicate records \u0925\u0947 \u0905\u092c \u0935\u0939 Merge \u0928\u0939\u0940\u0902 \u0939\u0941\u0935\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"3-group-concat-with-order-by\">3. GROUP_CONCAT With ORDER BY<\/h2>\n\n\n\n<p>\u092f\u0926\u093f \u0906\u092a merge \u0915\u093f\u090f data \u0915\u0908 Sequence \u092d\u0940 \u092c\u0926\u0932\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0924\u092c \u0906\u092a\u0915\u094b GROUP CONCAT \u092e\u0947 ORDER BY \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0928\u093e \u0939\u094b\u0917\u093e\u0964 <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u0939\u092e\u0928\u0947 \u092f\u0939 \u092a\u0930 Customer Name \u0915\u094b \u092d\u0940 Order \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u0907\u0938\u0932\u093f\u090f last \u092e\u0947 \u090f\u0915 \u092c\u093e\u0930 Order by \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u093f\u092f\u093e \u0939\u0948 \u0964 <\/li>\n\n\n\n<li>\u0906\u092a \u092f\u0939 \u092a\u0930 DESC \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 Order \u0915\u094b Descending \u092d\u0940 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/li>\n<\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT cust_nm, GROUP_CONCAT(item_nm ORDER BY item_nm) \nFROM citemmst \nGROUP BY cust_nm \nORDER BY cust_nm<\/code><\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"430\" height=\"112\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-20.png?resize=430%2C112&#038;ssl=1\" alt=\"group_concat with Order By\" class=\"wp-image-9827\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-20.png?w=430&amp;ssl=1 430w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-20.png?resize=300%2C78&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-20.png?resize=150%2C39&amp;ssl=1 150w\" sizes=\"auto, (max-width: 430px) 100vw, 430px\" \/><\/figure>\n<\/div>\n\n\n<p>\u0909\u092a\u0930\u094b\u0915\u094d\u0924 Example \u092e\u0947 \u0906\u092a \u0926\u0947\u0916 \u0930\u0939\u0947 \u0939\u094b\u0902\u0917\u0947 \u0915\u0908 \u0905\u092c \u091c\u094b Merge Data \u0939\u0948\u0902 \u0935\u0939 Alphabetic Order \u092e\u0947 sort \u0939\u094b \u0917\u092f\u093e \u0939\u0948\u0902\u0964 <\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"4-group-concat-with-separator\">4. GROUP_CONCAT With SEPARATOR<\/h2>\n\n\n\n<p>by Default \u0906\u092a \u091c\u092c \u092d\u0940 GROUP CONCAT \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0924\u092c \u092f\u0939 Comma (,) \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 Data \u0915\u094b concat \u0915\u0930\u0924\u093e \u0939\u0948\u0902\u0964 \u092f\u0926\u093f \u0906\u092a Comma \u0915\u0947 \u0938\u094d\u0925\u093e\u0928 \u092a\u0930 \u0915\u0941\u091b \u0914\u0930 \u092d\u0940 \u0932\u0917\u093e\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0924\u094b \u0906\u092a\u0915\u094b <strong>SEPARATOR<\/strong> \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0928\u093e \u0939\u094b\u0917\u093e\u0964  <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\">SELECT cust_nm, GROUP_CONCAT( item_nm  SEPARATOR ' -- ')\r\nfrom citemmst\r\ngroup by cust_nm<\/code><\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"380\" height=\"105\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-22.png?resize=380%2C105&#038;ssl=1\" alt=\"group_concat with Separator\" class=\"wp-image-9831\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-22.png?w=380&amp;ssl=1 380w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-22.png?resize=300%2C83&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/image-22.png?resize=150%2C41&amp;ssl=1 150w\" sizes=\"auto, (max-width: 380px) 100vw, 380px\" \/><\/figure>\n<\/div>\n\n\n<p>\u0909\u092a\u0930\u094b\u0915\u094d\u0924 Example \u092e\u0947 Separator \u0915\u093e \u0909\u092f\u094b\u0917 \u0915\u0930 \u0939\u092e\u0928\u0947 Comma \u0915\u0947 \u0938\u094d\u0925\u093e\u0928 \u092a\u0930 &#8212; \u0932\u093f\u092f\u093e \u0939\u0948\u0902\u0964 <\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>\u0906\u0936\u093e \u0939\u0948\u0902 \u092e\u0941\u091d\u0947 \u0915\u0940 \u0906\u092a\u0915\u094b MySQL Group Concat \u092c\u0939\u0941\u0924 \u0905\u091a\u094d\u091b\u0947 \u0938\u0947 \u0938\u092e\u091d \u092e\u0947 \u0906 \u0917\u092f\u093e \u0939\u094b\u0917\u093e, \u092f\u0926\u093f \u092b\u093f\u0930 \u092d\u0940 \u0906\u092a\u0915\u0947 \u0915\u094b\u0908 Doubts \u0939\u0948\u0902 \u0924\u094b \u0906\u092a \u092e\u0941\u091d\u0947 Comment \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<p>\u092f\u0939 article \u0915\u0948\u0938\u093e \u0932\u0917\u093e \u092c\u0924\u093e\u0928\u093e \u0928 \u092d\u0942\u0932\u0947 , \u0905\u092a\u0928\u093e \u0915\u0940\u092e\u0924\u0940 \u0938\u092e\u092f \u0926\u0947\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0927\u0928\u094d\u092f\u0935\u093e\u0926 \u0964 <\/p>\n\n\n\n<p>  <\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"strong-\u0939\u092e\u093e\u0930\u0947-\u0905\u0928\u094d\u092f-\u0906\u0930\u094d\u091f\u093f\u0915\u0932-strong\"><strong>\u0939\u092e\u093e\u0930\u0947 \u0905\u0928\u094d\u092f \u0906\u0930\u094d\u091f\u093f\u0915\u0932<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-function\/\">MySQL Function<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-stored-procedure\/\">MySQL Stored Procedure<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/get-post-method\/\">PHP Get \/Post Method \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u091c\u093e\u0928\u0947<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/php-math-function\/\">PHP Math Function \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u091c\u093e\u0928\u0947<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/learn-cpp-from-c\/\">C \u0938\u0947 C ++ \u0938\u0940\u0916\u0947 \u0938\u0930\u0932 \u0936\u092c\u094d\u0926\u094b\u0902 \u092e\u0947\u0902<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/php-variables\/\">PHP Variable \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u091c\u093e\u0928\u0947<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/arduino-control-structure\/\">Arduino Control Structure<\/a>&nbsp;<\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/c-union\/\">Union in C<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/c-pointer\/\">Declaration of Pointer in C<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/search-jquery\/\">jQuery Search Filter<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-table-create-alter-drop\/\">MySQL Create Table | Alter Table | Drop Table<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/api-using-node-react-express-mysql\/\">API Using NODE REACT EXPRESS MYSQL SEQUELIZE (For Backend OR Server Side)<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/cpanel\/\">CPANEL In Hindi<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Group_concat in sql, how to merge string in mysql, string aggregation, How to order Group concat in SQL? \u091c\u092c \u092d\u0940 \u0939\u092e \u090f\u0915 \u0938\u0947 \u0905\u0927\u093f\u0915 Rows \u0915\u0940 String Value \u0915\u094b \u091c\u094b\u095c\u0928\u093e \u0939\u094b \u0924\u092c \u0939\u092e Group_Concat \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964 \u090f\u0915 \u0924\u0930\u0939 \u0938\u0947 \u0939\u092e \u0907\u0938\u0947 Aggregate Function \u092d\u0940 \u0915\u0939 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0915\u094d\u092f\u0941\u0915\u0940 \u092f\u0939 Rows \u0915\u094b Group [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":9886,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[5],"tags":[],"class_list":["post-9529","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/12\/MySQL-Group-Concat.jpg?fit=1200%2C628&ssl=1","_links":{"self":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/9529","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/comments?post=9529"}],"version-history":[{"count":69,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/9529\/revisions"}],"predecessor-version":[{"id":9888,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/9529\/revisions\/9888"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media\/9886"}],"wp:attachment":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media?parent=9529"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/categories?post=9529"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/tags?post=9529"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}