{"id":596,"date":"2012-11-12T08:46:47","date_gmt":"2012-11-12T07:46:47","guid":{"rendered":"http:\/\/blog.techmedia.pl\/?p=596"},"modified":"2012-11-12T08:46:47","modified_gmt":"2012-11-12T07:46:47","slug":"mysql-update-2-tabel","status":"publish","type":"post","link":"https:\/\/www.techmedia.pl\/blog\/mysql-update-2-tabel\/","title":{"rendered":"MySQL – update 2 tabel"},"content":{"rendered":"

Czasami zachodzi w MySQL potrzeba wykonania update’u jednej tabeli na podstawie informacji przechowywanych w innej tabeli. Mo\u017cna to zrobi\u0107 poni\u017cszym poleceniem:<\/p>\n

UPDATE tb1 INNER JOIN tb2 ON tb1.pole1=tb2.pole2 set tb1.pole3='wartosc' WHERE tb2.pole4='warunek';<\/pre>\n
gdzie: tb1 – tabela 1, tb2 – tabela 2, pole1 – pole z\u0142\u0105czenia 1 tabeli, pole2 – pole z\u0142\u0105czenia 2 tabeli, pole3 – w pole wpisujemy now\u0105 \u201awartosc\u2019, pole4 – pole tabeli obcej spe\u0142niaj\u0105ce podany \u201awarunek\u2019.<\/p>\n","protected":false},"excerpt":{"rendered":"
Czasami zachodzi w MySQL potrzeba wykonania update’u jednej tabeli na podstawie informacji przechowywanych w innej tabeli. Mo\u017cna to zrobi\u0107 poni\u017cszym poleceniem: UPDATE tb1 INNER JOIN tb2 ON tb1.pole1=tb2.pole2 set tb1.pole3=’wartosc\u2019 WHERE tb2.pole4=’warunek\u2019; gdzie: tb1 – tabela 1, tb2 – tabela 2, pole1 – pole z\u0142\u0105czenia 1 tabeli, pole2 – pole z\u0142\u0105czenia 2 tabeli, pole3 – […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[15],"tags":[132,135,134,133],"yst_prominent_words":[],"_links":{"self":[{"href":"https:\/\/www.techmedia.pl\/blog\/wp-json\/wp\/v2\/posts\/596"}],"collection":[{"href":"https:\/\/www.techmedia.pl\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.techmedia.pl\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.techmedia.pl\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.techmedia.pl\/blog\/wp-json\/wp\/v2\/comments?post=596"}],"version-history":[{"count":1,"href":"https:\/\/www.techmedia.pl\/blog\/wp-json\/wp\/v2\/posts\/596\/revisions"}],"predecessor-version":[{"id":597,"href":"https:\/\/www.techmedia.pl\/blog\/wp-json\/wp\/v2\/posts\/596\/revisions\/597"}],"wp:attachment":[{"href":"https:\/\/www.techmedia.pl\/blog\/wp-json\/wp\/v2\/media?parent=596"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.techmedia.pl\/blog\/wp-json\/wp\/v2\/categories?post=596"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.techmedia.pl\/blog\/wp-json\/wp\/v2\/tags?post=596"},{"taxonomy":"yst_prominent_words","embeddable":true,"href":"https:\/\/www.techmedia.pl\/blog\/wp-json\/wp\/v2\/yst_prominent_words?post=596"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}