{"id":368,"date":"2017-11-10T10:06:19","date_gmt":"2017-11-10T10:06:19","guid":{"rendered":"http:\/\/www.josejavierfm.es\/blog\/?p=368"},"modified":"2017-11-10T10:06:19","modified_gmt":"2017-11-10T10:06:19","slug":"agrupar-multiples-valores-en-una-sola-columna-mysql","status":"publish","type":"post","link":"https:\/\/www.josejavierfm.es\/blog\/2017\/11\/10\/agrupar-multiples-valores-en-una-sola-columna-mysql\/","title":{"rendered":"Agrupar multiples valores en una sola columna mysql"},"content":{"rendered":"<p>Partimos de la siguiente estructura:<br \/>\n<a href=\"http:\/\/www.josejavierfm.es\/blog\/wp-content\/uploads\/2017\/11\/blog-agrupar-multiples-valores-en-una-sola-columna-mysql-2017-11-10-10-57-43-untitled-model-navicat-premium.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-medium wp-image-372\" src=\"http:\/\/www.josejavierfm.es\/blog\/wp-content\/uploads\/2017\/11\/blog-agrupar-multiples-valores-en-una-sola-columna-mysql-2017-11-10-10-57-43-untitled-model-navicat-premium-300x108.png\" alt=\"\" width=\"300\" height=\"108\" srcset=\"https:\/\/www.josejavierfm.es\/blog\/wp-content\/uploads\/2017\/11\/blog-agrupar-multiples-valores-en-una-sola-columna-mysql-2017-11-10-10-57-43-untitled-model-navicat-premium-300x108.png 300w, https:\/\/www.josejavierfm.es\/blog\/wp-content\/uploads\/2017\/11\/blog-agrupar-multiples-valores-en-una-sola-columna-mysql-2017-11-10-10-57-43-untitled-model-navicat-premium.png 426w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>Donde tenemos datos en las dos tablas<\/p>\n<p><strong>Nombres:<\/strong><br \/>\n<a href=\"http:\/\/www.josejavierfm.es\/blog\/wp-content\/uploads\/2017\/11\/blog-agrupar-multiples-valores-en-una-sola-columna-mysql-2017-11-10-11-00-33-nombres-test-local-table-navicat-premium.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-medium wp-image-371\" src=\"http:\/\/www.josejavierfm.es\/blog\/wp-content\/uploads\/2017\/11\/blog-agrupar-multiples-valores-en-una-sola-columna-mysql-2017-11-10-11-00-33-nombres-test-local-table-navicat-premium.png\" alt=\"\" width=\"145\" height=\"88\" \/><\/a><\/p>\n<p><strong>Etiquetas:<\/strong><br \/>\n<a href=\"http:\/\/www.josejavierfm.es\/blog\/wp-content\/uploads\/2017\/11\/blog-agrupar-multiples-valores-en-una-sola-columna-mysql-2017-11-10-11-00-43-tags-test-local-table-navicat-premium.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-medium wp-image-370\" src=\"http:\/\/www.josejavierfm.es\/blog\/wp-content\/uploads\/2017\/11\/blog-agrupar-multiples-valores-en-una-sola-columna-mysql-2017-11-10-11-00-43-tags-test-local-table-navicat-premium.png\" alt=\"\" width=\"216\" height=\"177\" \/><\/a><\/p>\n<p>el resultados que queremos es:<br \/>\n<a href=\"http:\/\/www.josejavierfm.es\/blog\/wp-content\/uploads\/2017\/11\/blog-agrupar-multiples-valores-en-una-sola-columna-mysql-2017-11-10-11-01-52-untitled-test-local-query-navicat-premium.png\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-medium wp-image-369\" src=\"http:\/\/www.josejavierfm.es\/blog\/wp-content\/uploads\/2017\/11\/blog-agrupar-multiples-valores-en-una-sola-columna-mysql-2017-11-10-11-01-52-untitled-test-local-query-navicat-premium-300x71.png\" alt=\"\" width=\"300\" height=\"71\" srcset=\"https:\/\/www.josejavierfm.es\/blog\/wp-content\/uploads\/2017\/11\/blog-agrupar-multiples-valores-en-una-sola-columna-mysql-2017-11-10-11-01-52-untitled-test-local-query-navicat-premium-300x71.png 300w, https:\/\/www.josejavierfm.es\/blog\/wp-content\/uploads\/2017\/11\/blog-agrupar-multiples-valores-en-una-sola-columna-mysql-2017-11-10-11-01-52-untitled-test-local-query-navicat-premium.png 377w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>La sql necesaria es:<\/p>\n<pre>select e.*,\r\n\t(SELECT GROUP_CONCAT(tag SEPARATOR ', ') FROM tags where idnombre=e.id) as tags\r\n\tfrom nombres e\r\n<\/pre>\n\n<div class=\"twitter-share\"><a href=\"https:\/\/twitter.com\/intent\/tweet?via=josejavierfm\" class=\"twitter-share-button\">Twittear<\/a><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Partimos de la siguiente estructura: Donde tenemos datos en las dos tablas Nombres: Etiquetas: el resultados que queremos es: La sql necesaria es: select e.*, (SELECT GROUP_CONCAT(tag SEPARATOR &#8216;, &#8216;) FROM tags where idnombre=e.id) as tags from nombres e<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[7],"tags":[],"_links":{"self":[{"href":"https:\/\/www.josejavierfm.es\/blog\/wp-json\/wp\/v2\/posts\/368"}],"collection":[{"href":"https:\/\/www.josejavierfm.es\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.josejavierfm.es\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.josejavierfm.es\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.josejavierfm.es\/blog\/wp-json\/wp\/v2\/comments?post=368"}],"version-history":[{"count":1,"href":"https:\/\/www.josejavierfm.es\/blog\/wp-json\/wp\/v2\/posts\/368\/revisions"}],"predecessor-version":[{"id":373,"href":"https:\/\/www.josejavierfm.es\/blog\/wp-json\/wp\/v2\/posts\/368\/revisions\/373"}],"wp:attachment":[{"href":"https:\/\/www.josejavierfm.es\/blog\/wp-json\/wp\/v2\/media?parent=368"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.josejavierfm.es\/blog\/wp-json\/wp\/v2\/categories?post=368"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.josejavierfm.es\/blog\/wp-json\/wp\/v2\/tags?post=368"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}