{"id":38,"date":"2010-06-15T09:59:57","date_gmt":"2010-06-15T09:59:57","guid":{"rendered":""},"modified":"2012-06-08T12:42:26","modified_gmt":"2012-06-08T04:42:26","slug":"update-multiple-rows-at-once-with-different-conditions","status":"publish","type":"post","link":"https:\/\/matnet.my\/blog\/2010\/06\/update-multiple-rows-at-once-with-different-conditions\/","title":{"rendered":"Update multiple rows at once with different conditions."},"content":{"rendered":"

sebagai contoh – sempena worldcup 2010<\/p>\n

Table – gol<\/p>\n

negara kekerapan_gol<\/p>\n

brazil 10
\nportugal 11
\njapan 8<\/p>\n

so now kita mau update table gol serentak, bley guna mysql case statement.<\/p>\n

[quote]<\/p>\n

UPDATE gol SET<\/p>\n

kekerapan_gol = CASE
\nWHEN negara = ‘brazil’ THEN ‘$jumgolbarubrazil’
\nWHEN negara = ‘portugal’ THEN ‘$jumgolbaruportugal’
\nWHEN negara = ‘japan’ THEN ‘$jumgolbarujapan’
\nELSE kajian END<\/p>\n

[\/quote]<\/p>\n","protected":false},"excerpt":{"rendered":"

sebagai contoh – sempena worldcup 2010 Table – gol negara kekerapan_gol brazil 10 portugal 11 japan 8 so now kita … More Update multiple rows at once with different conditions.<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-38","post","type-post","status-publish","format-standard","hentry","category-www","standard"],"_links":{"self":[{"href":"https:\/\/matnet.my\/blog\/wp-json\/wp\/v2\/posts\/38","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/matnet.my\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/matnet.my\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/matnet.my\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/matnet.my\/blog\/wp-json\/wp\/v2\/comments?post=38"}],"version-history":[{"count":2,"href":"https:\/\/matnet.my\/blog\/wp-json\/wp\/v2\/posts\/38\/revisions"}],"predecessor-version":[{"id":60,"href":"https:\/\/matnet.my\/blog\/wp-json\/wp\/v2\/posts\/38\/revisions\/60"}],"wp:attachment":[{"href":"https:\/\/matnet.my\/blog\/wp-json\/wp\/v2\/media?parent=38"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/matnet.my\/blog\/wp-json\/wp\/v2\/categories?post=38"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/matnet.my\/blog\/wp-json\/wp\/v2\/tags?post=38"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}