{"id":129,"date":"2011-10-02T12:03:20","date_gmt":"2011-10-02T12:03:20","guid":{"rendered":"http:\/\/sql.programisius.lt\/?page_id=129"},"modified":"2011-10-02T12:22:49","modified_gmt":"2011-10-02T12:22:49","slug":"5-duomenu-iterpimas","status":"publish","type":"page","link":"http:\/\/sql.programisius.lt\/?page_id=129","title":{"rendered":"5. Duomen\u0173 \u012fterpimas"},"content":{"rendered":"

 <\/p>\n

INSERT INTO darbuotojai_??? (vardas, pavarde, pareigos, amzius, alga) VALUES (‘Ona’, ‘Petraityt\u0117’,’Sekretor\u0117’,28,\u00a0 18700.00);<\/p>\n

INSERT INTO darbuotojai_??? (vardas, pavarde, pareigos, amzius, alga) VALUES (‘Antanas’, ‘Jonaitis’,’Programuotojas’,32,\u00a0 47000.00);<\/p>\n

INSERT INTO darbuotojai_??? (vardas, pavarde, pareigos, amzius, alga) VALUES (‘Algis’, ‘\u0104\u017euolaitis’,’Programuotojas’,57,\u00a0 73000.00);<\/p><\/blockquote>\n

1.<\/p>\n

\u00a0SELECT * FROM darbuotojai_???;<\/p><\/blockquote>\n

2.<\/p>\n

\u00a0SELECT * FROM darbuotojai_??? WHERE alga > 25000.00;<\/p><\/blockquote>\n

3.<\/p>\n

\u00a0SELECT vardas, pavarde FROM darbuotojai_??? WHERE amzius > 30;<\/p><\/blockquote>\n

4.<\/p>\n

\u00a0SELECT vardas, pavarde, alga FROM darbuotojai_??? WHERE pareigos = ‘Programuotojas’;<\/p><\/blockquote>\n

5.<\/p>\n

\u00a0SELECT * FROM darbuotojai_??? WHERE pavarde LIKE’%yt\u0117’;<\/p><\/blockquote>\n

6.<\/p>\n

\u00a0SELECT * FROM darbuotojai_??? WHERE vardas LIKE ‘Algis’;<\/p><\/blockquote>\n

7.<\/p>\n

\u00a0SELECT * FROM darbuotojai_??? WHERE amzius > 90;<\/p><\/blockquote>\n

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

  INSERT INTO darbuotojai_??? (vardas, pavarde, pareigos, amzius, alga) VALUES (‘Ona’, ‘Petraityt\u0117’,’Sekretor\u0117’,28,\u00a0 18700.00); INSERT INTO darbuotojai_??? (vardas, pavarde, pareigos, amzius, alga) VALUES (‘Antanas’, ‘Jonaitis’,’Programuotojas’,32,\u00a0 47000.00); INSERT INTO darbuotojai_??? (vardas, pavarde, pareigos, amzius, alga) VALUES (‘Algis’, ‘\u0104\u017euolaitis’,’Programuotojas’,57,\u00a0 73000.00); 1. \u00a0SELECT * FROM darbuotojai_???; 2. \u00a0SELECT * FROM darbuotojai_??? WHERE alga > 25000.00; 3. \u00a0SELECT vardas, pavarde […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":115,"menu_order":5,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-129","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/129","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=129"}],"version-history":[{"count":4,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/129\/revisions"}],"predecessor-version":[{"id":131,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/129\/revisions\/131"}],"up":[{"embeddable":true,"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=\/wp\/v2\/pages\/115"}],"wp:attachment":[{"href":"http:\/\/sql.programisius.lt\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=129"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}