{"id":59,"date":"2011-09-27T11:36:02","date_gmt":"2011-09-27T11:36:02","guid":{"rendered":"http:\/\/sql.programisius.lt\/?page_id=59"},"modified":"2011-10-02T12:16:56","modified_gmt":"2011-10-02T12:16:56","slug":"7-duomenu-salinimas","status":"publish","type":"page","link":"http:\/\/sql.programisius.lt\/?page_id=59","title":{"rendered":"7. Duomen\u0173 \u0161alinimas"},"content":{"rendered":"<p>Duomen\u0173 \u0161alinimui yra naudojamas SQL raktinis \u017eodis DELETE. Po to nurodoma i\u0161 kokios lentel\u0117s reikia<br \/>\ni\u0161trinti ir kokius duomenis.<\/p>\n<blockquote><p><span style=\"color: #000080;\">DELETE FROM lenteles_vardas<\/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 operatoriai (&gt;,&lt;, !=, LIKE ir kt.)<\/span><\/p><\/blockquote>\n<p>Pavyzdys:<\/p>\n<blockquote><p><span style=\"color: #000080;\">DELETE FROM darbuotojai<\/span><br \/>\n<span style=\"color: #000080;\"> WHERE pavard\u0117 = `Jonaitien\u0117`;<\/span><\/p>\n<p><span style=\"color: #000080;\">DELETE FROM darbuotojai<\/span><br \/>\n<span style=\"color: #000080;\"> WHERE pavard\u0117 = `Petraitis` OR pavard\u0117 = `Jonaitis;<\/span><\/p><\/blockquote>\n<p>Jeigu neb\u016bt\u0173 WHERE s\u0105lygos, tai DELETE FROM i\u0161trint\u0173 visus lentel\u0117s \u012fra\u0161us.<\/p>\n<p><strong>Duomen\u0173 \u0161alinimo u\u017eduotys<\/strong><\/p>\n<p>1. Ona Jonaitien\u0117 i\u0161\u0117jo i\u0161 darbo. Pa\u0161alinkite jos \u012fra\u0161\u0105.<br \/>\n2. Laikas ma\u017einti biud\u017eet\u0105. Pa\u0161alinkite visus darbuotojus, kurie u\u017edirba ma\u017eiau nei 50000.<br \/>\n3. Sugalvokite dar\u00a0vien\u0105 u\u017eklaus\u0105, kuri pa\u0161alint\u0173 kitus duomenis.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Duomen\u0173 \u0161alinimui yra naudojamas SQL raktinis \u017eodis DELETE. Po to nurodoma i\u0161 kokios lentel\u0117s reikia i\u0161trinti ir kokius duomenis. DELETE FROM lenteles_vardas WHERE stulpelio_vardas OPERATORIUS vert\u0117 [AND||OR stulpelio_vardas OPERATORIUS \u201evert\u0117]; [] \u2013 pasirinktinai ||\u00a0 \u2013 arba OPERATORIUS \u2013 palyginimo operatoriai (&gt;,&lt;, !=, LIKE ir kt.) Pavyzdys: DELETE FROM darbuotojai WHERE pavard\u0117 = `Jonaitien\u0117`; DELETE FROM [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":2,"menu_order":7,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-59","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/59","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=59"}],"version-history":[{"count":5,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/59\/revisions"}],"predecessor-version":[{"id":61,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/59\/revisions\/61"}],"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=59"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}