sql dml buyruqlari (insert, update, delete, merge)

sql тили reja 1. insert operatori 2. update operatori 3. delete operatori 4. murakkab so’rovlar. ma’lumotlarni qayta ishlash sql operatorlari dml buyruqlari 5 ta dml buyrug’i mavjud: select insert update delete merge professionallar select buyrug’ini ko’pincha dmlga kiritishmaydi. merge buyrug’i esa sqlning yangi versiyalarida ishlaydi. ma`lumotlarni kiritish ma`lumotlar insert operatori orqali kiritiladi. insert into jadval_nomi [( ) ] values ( ) masalan, books jadvaliga yangi kitob ma`lumotlari kiritiladi insert into books ( isbn, titl, autor, coautor, yearizd, pages) values (‘5-88782-290-2’, ’аппаратные средства ibm pc. энциклопедия’, ‘гук m. ‘, ‘ ‘,2000, 816) insert operatori misollar insert into regions values (10,’great britain’); insert into regions (region_name, region_id) values (...

This file contains 22 pages in PPTX format (75.7 KB). To download "sql dml buyruqlari (insert, update, delete, merge)", click the Telegram button on the left.