{"id":55,"date":"2011-09-27T11:13:59","date_gmt":"2011-09-27T11:13:59","guid":{"rendered":"http:\/\/sql.programisius.lt\/?page_id=55"},"modified":"2011-10-02T12:06:14","modified_gmt":"2011-10-02T12:06:14","slug":"6-duomenu-atnaujinimas","status":"publish","type":"page","link":"http:\/\/sql.programisius.lt\/?page_id=55","title":{"rendered":"6. Atnaujinimas"},"content":{"rendered":"<p>Duomen\u0173 atnaujinimui ir keitimui \u012fra\u0161uose yra naudojama komanda UPDATE, toms eilut\u0117s, kurios atitinka keliamus reikalavimus. Reikalavimai kei\u010diamoms eilut\u0117ms yra pateikiami po WHERE rekata\u017eod\u017eio. Atnaujinimo SQL \u0161ablonas:<\/p>\n<blockquote><p><span style=\"color: #000080;\">\u00a0UPADTE lenteles_vardas<\/span><br \/>\n<span style=\"color: #000080;\"> SET stulpelio_vardas1 =<\/span><br \/>\n<span style=\"color: #000080;\"> `vert\u01171` [, &#8230;, stulpelio_vardasN=vert\u0117N]<\/span><br \/>\n<span style=\"color: #000080;\"> WHERE stulpelio_vardas<\/span><br \/>\n<span style=\"color: #000080;\"> OPERATORIUS vert\u0117 [AND||OR stulpelio_vardas OPERATORIUS \u201evert\u0117];<\/span><\/p>\n<p><span style=\"color: #000080;\">[] \u2013 pasirinktinai<\/span><br \/>\n<span style=\"color: #000080;\"> ||\u00a0 \u2013 arba<\/span><br \/>\n<span style=\"color: #000080;\"> OPERATORIUS \u2013 palyginimo<\/span><br \/>\n<span style=\"color: #000080;\"> operatoriai (&gt;,&lt;, !=, LIKE ir kt.)<\/span><\/p><\/blockquote>\n<p>&nbsp;<\/p>\n<p>Pavyzd\u017eiui:<\/p>\n<blockquote><p><span style=\"color: #000080;\">UPDATE telefonu_knyga<\/span><br \/>\n<span style=\"color: #000080;\"> SET mobilus_kodas = 671<\/span><br \/>\n<span style=\"color: #000080;\"> WHERE numeris = 10101;<\/span><\/p>\n<p><span style=\"color: #000080;\">UPDATE telefonu_knyga<\/span><br \/>\n<span style=\"color: #000080;\"> SET pavarde = `Jonaitis`,<\/span><br \/>\n<span style=\"color: #000080;\"> numeris = 55555, mobilus_kodas = 671<\/span><br \/>\n<span style=\"color: #000080;\"> WHERE pavarde = `Petraitis`;<\/span><\/p>\n<p><span style=\"color: #000080;\">UPDATE darbuotojai<\/span><br \/>\n<span style=\"color: #000080;\"> SET amzius = amzius+1<\/span><br \/>\n<span style=\"color: #000080;\"> WHERE pavarde = `Inga` AND pavarde =`Ingait\u0117`;<\/span><\/p><\/blockquote>\n<p>&nbsp;<\/p>\n<p><strong>Duomen\u0173 atnaujinimo u\u017eduotys su UPDATE:<\/strong><\/p>\n<p>Po kiekvienos UPDATE komandos naudokite duomen\u0173 per\u017ei\u016br\u0105 (su SELECT).<\/p>\n<p>1. Ona Petraityt\u0117 tik k\u0105 i\u0161tek\u0117jo u\u017e Jono Jonai\u010dio. Jai reikia pakeisti pavard\u0117 \u012f Jonaitien\u0117.<br \/>\n2. \u0160iandien Antano Jonai\u010dio gimtadienis. Padidinkite jo am\u017ei\u0173.<br \/>\n3. Visos sekretor\u0117s dabar yra vadinamos \u201eAdministrator\u0117s\u201c. Atnaujinkite visas pareigybes.<br \/>\n4. Visiems, kurie u\u017edirba daugiau nei 35000, pakeliama alga 1600.<br \/>\n5. Visi tie, kuri\u0173 pareigyb\u0117s \u201eProgramuotojas\u201c tampa \u201eVyr. Programuotojas\u201c.<br \/>\n6. Sugalvoti dar ma\u017eiausiai 3 atnaujinimo u\u017eklausas.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Duomen\u0173 atnaujinimui ir keitimui \u012fra\u0161uose yra naudojama komanda UPDATE, toms eilut\u0117s, kurios atitinka keliamus reikalavimus. Reikalavimai kei\u010diamoms eilut\u0117ms yra pateikiami po WHERE rekata\u017eod\u017eio. Atnaujinimo SQL \u0161ablonas: \u00a0UPADTE lenteles_vardas SET stulpelio_vardas1 = `vert\u01171` [, &#8230;, stulpelio_vardasN=vert\u0117N] WHERE stulpelio_vardas OPERATORIUS vert\u0117 [AND||OR stulpelio_vardas OPERATORIUS \u201evert\u0117]; [] \u2013 pasirinktinai ||\u00a0 \u2013 arba OPERATORIUS \u2013 palyginimo operatoriai (&gt;,&lt;, !=, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":2,"menu_order":6,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-55","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/55","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=55"}],"version-history":[{"count":6,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/55\/revisions"}],"predecessor-version":[{"id":57,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/55\/revisions\/57"}],"up":[{"embeddable":true,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/2"}],"wp:attachment":[{"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=55"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}