Ankara Üniversitesi
Nallıhan Meslek Yüksekokulu
Veri İşleme Dili (DML)
NB P124 VE R I T AB ANI YÖNE T IM SIST E ML E R I ÖĞR . GÖR . MAHMUT KIL IÇ ASL AN
Veri Eklemek: Insert
INSERT INTO table_name (column1, column2, column3, ...) VALUES (value1, value2, value3, ...)
INSERT INTO Customers (CompanyName, ContactName, Address, City, PostalCode, Country) VALUES ('XYZ Yazilim', 'Meral Paşa', '1949.
Cad. No:21', 'Ankara', '06100', 'Türkiye');
Veri Seçmek :Select
select column1, column2, ... from table_name;
select * from table_name;
select CompanyName, City from Customers;
select * from Customers;
Seçilen Kayıtları Sıralamak: Order By
select column1, column2, ... from table_name order by column1, column2, ... asc|desc;
select * from Customers order by Country;
select * from Customers order by Country desc;
select * from Customers order by Country, CompanyName;
select * from Customers order by Country asc, CompanyName desc;
Seçilen Kayıtları Filtrelemek: Where
select column1, column2, ... from table_name where condition;
select * from Customers where Country='Mexico';
select * from Customers where CustomerID=1;
Verilerde Değişiklik Yapmak:Update
update table_name set column1 = value1, column2 = value2, ...
where condition;
update Customers set ContactName = 'Alfred Schmidt', City=
'Frankfurt' where CustomerID = 1;
update Customers set ContactName='Juan' where Country='Mexico';
Verileri Silmek : Delete
delete from table_name where condition;
delete from Customers where CompanyName='Alfreds Futterkiste';
delete from table_name;
delete from Customers;
KAYNAKLAR
[1] https://www.w3schools.com/sql/default.asp
[2]Yazılımcılar için SQL Server ve Veritabanı Programlama,2014, Seçkin Yayıncılık