{"id":2154,"date":"2021-10-29T21:56:10","date_gmt":"2021-10-30T02:56:10","guid":{"rendered":"https:\/\/creativapixel.com\/?p=2154"},"modified":"2021-10-29T22:14:41","modified_gmt":"2021-10-30T03:14:41","slug":"actualizar-registros-mediante-subquery-en-mariadb","status":"publish","type":"post","link":"https:\/\/creativapixel.com\/blog\/actualizar-registros-mediante-subquery-en-mariadb\/","title":{"rendered":"Actualizar registros mediante Subquery en mariadb"},"content":{"rendered":"\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"539\" height=\"395\" src=\"https:\/\/creativapixel.com\/wp-content\/uploads\/2021\/10\/update-subquery-mariadb.jpg\" alt=\"\" class=\"wp-image-2157\" srcset=\"https:\/\/creativapixel.com\/blog\/wp-content\/uploads\/2021\/10\/update-subquery-mariadb.jpg 539w, https:\/\/creativapixel.com\/blog\/wp-content\/uploads\/2021\/10\/update-subquery-mariadb-300x220.jpg 300w\" sizes=\"auto, (max-width: 539px) 100vw, 539px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">En este caso, tomamos como ejemplo una tabla \u00ablog_consumos\u00bb de una base de datos hotelera que contiene tres claves for\u00e1neas:  con_id, alo_id y res_id, que corresponden al id de una tabla consumo, el id de una tabla alojamiento y el id de una tabla reservas respectivamente. Sucede que los campos alo_id y res_id se han agregado reci\u00e9n a la tabla log_consumo y queremos agregar  datos a los campos alo_id y res_id que tambi\u00e9n tiene la tabla \u00abconsumo\u00bb, todo en relaci\u00f3n al campo con_id. Para actualizar registros en estos campos usamos la siguiente sentencia:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>UPDATE log_consumos AS lc \nINNER JOIN (<strong>SELECT l.con_id,c.alo_id,c.res_id FROM log_consumos AS l INNER JOIN consumo AS c ON l.con_id=c.con_id WHERE l.alo_id IS NULL<\/strong>) AS sq ON lc.con_id=sq.con_id \nSET lc.alo_id=sq.alo_id, lc.res_id =sq.res_id \n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>En este caso, tomamos como ejemplo una tabla \u00ablog_consumos\u00bb de una base de datos hotelera que contiene tres claves for\u00e1neas: con_id, alo_id y res_id, que corresponden al id de una &#8230;<\/p>\n","protected":false},"author":1,"featured_media":2155,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[48,38],"tags":[],"class_list":["post-2154","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mariadb","category-mysql"],"_links":{"self":[{"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/posts\/2154","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/comments?post=2154"}],"version-history":[{"count":3,"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/posts\/2154\/revisions"}],"predecessor-version":[{"id":2159,"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/posts\/2154\/revisions\/2159"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/media\/2155"}],"wp:attachment":[{"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/media?parent=2154"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/categories?post=2154"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/tags?post=2154"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}