b'\n_START_ARTICLE_\nUpdate (SQL)\n_START_PARAGRAPH_\nSQL valod\xc4\x81 komanda UPDATE izmaina datus vien\xc4\x81 vai vair\xc4\x81kos ierakstos. Datus var izmain\xc4\xabt vai nu vis\xc4\x81s rind\xc4\x81s vai ar\xc4\xab izv\xc4\x93l\xc4\x93taj\xc4\x81s rind\xc4\x81s, izmantojot nosac\xc4\xabjumu.\n_START_SECTION_\nPiem\xc4\x93ri\n_START_PARAGRAPH_\nTabul\xc4\x81 T izmain\xc4\xabt kolonnas C1 v\xc4\x93rt\xc4\xabbu uz 1 tikai t\xc4\x81m rind\xc4\x81m, kur\xc4\x81m kolonnas C2 v\xc4\x93rt\xc4\xabba ir "a"._NEWLINE__NEWLINE_ UPDATE T SET C1 = 1 WHERE C2 = \'a\'_NEWLINE_Tabul\xc4\x81 T izmain\xc4\xabt kolonnas C1 v\xc4\x93rt\xc4\xabbu uz 9 un kolonnas C3 v\xc4\x93rt\xc4\xabbu uz 4 tikai t\xc4\x81m rind\xc4\x81m, kur\xc4\x81m kolonnas C2 v\xc4\x93rt\xc4\xabba ir "a"._NEWLINE__NEWLINE_ UPDATE T SET C1 = 9, C3 = 4 WHERE C2 = \'a\'_NEWLINE_Paaugstin\xc4\x81t kolonnas C1 v\xc4\x93rt\xc4\xabbu par 1, ja kolonnas C2 v\xc4\x93rt\xc4\xabba ir "a"._NEWLINE__NEWLINE_ UPDATE T SET C1 = C1 + 1 WHERE C2 = \'a\'_NEWLINE_Kolonas C1 v\xc4\x93rt\xc4\xabbas s\xc4\x81kum\xc4\x81 pievienot tekstu "text", ja kolonas C2 v\xc4\x93rt\xc4\xabba ir "a"._NEWLINE__NEWLINE_ UPDATE T SET C1 = \'text\' || C1 WHERE C2 = \'a\'_NEWLINE_Tabul\xc4\x81 T1 izmain\xc4\xabt kolonnas C1 v\xc4\x93rt\xc4\xabbu uz 2 tikai tad, ja kolonnas C2 v\xc4\x93rt\xc4\xabba ir atrodama tabulas T2 kolonn\xc4\x81 C3 un kolonnas C4 v\xc4\x93rt\xc4\xabba ir 0._NEWLINE__NEWLINE_     UPDATE T1 _NEWLINE_     SET    C1 = 2    _NEWLINE_     WHERE  C2 IN ( SELECT C3_NEWLINE_               FROM   T2_NEWLINE_               WHERE  C4 = 0)_NEWLINE_Vien\xc4\x81 komand\xc4\x81 var tikt izlabotas vair\xc4\x81kas kolonnas:_NEWLINE__NEWLINE_ UPDATE T SET C1 = 1, C2 = 2_NEWLINE_Ir iesp\xc4\x93jami ar\xc4\xab kompleksi nosac\xc4\xabjumi:_NEWLINE__NEWLINE_ UPDATE T SET A = 1 WHERE C1 = 1 AND C2 = 2_NEWLINE__NEWLINE_ UPDATE a_NEWLINE_     SET a.[kolonna] = v\xc4\x93rt\xc4\xabba_NEWLINE_     FROM articles a _NEWLINE_     JOIN classification c _NEWLINE_     ON a.articleID = c.articleID _NEWLINE_     WHERE c.classID = 1'