Notes

use MuzeliVeriTabanı
go



/* SELECT*/
select * from tbl_muze
go
select * from tbl_kart where kart_Fiyat between 30 and 170
go
select * from tbl_kart where kart_Ad like '__A%'
go
select * from tbl_kart order by kart_Fiyat asc
go
select * from tbl_Uye where uye_ad<>'Ahmet' OR uye_adres!='esenyurt'
go
select upper(Uye_ad) from tbl_Uye
go

/*İNSERT İNTO*/
insert into tbl_il values('adıyaman')
go
insert into tbl_ilce(ilce_ad) values ('Siverek')
go
insert into tbl_Uye(uye_ad,uye_adres,uye_tel) values('Ahmet', 'esenyurt','5555555')
go
insert into tbl_kart(kart_Ad,kart_Fiyat,kart_Tarih) values ('İndirimli','350','01-01-2023')
go
insert into tbl_satis(kart_id,uye_id,muze_id) values ('2','2','3')
go
/* DELETE */

delete from tbl_satis where satis_id>8
go
delete from tbl_ilce where ilce_ad!='Beştepe' OR ilce_id>10
go
delete from tbl_kart where kart_Ad!='Sonsuz'
go
delete from tbl_satis where kart_id>8
go
delete from tbl_Uye where uye_ad!='Ahmet' and uye_tel='5555555' and uye_ıd>5
go

/*UPDATE */

update tbl_kart set kart_Ad='Sonsuzluk' where kart_Ad like 'Sonsuz'

go
update tbl_kart set kart_Ad='Aylık(indirimli)' where kart_Ad like 'Aylık'
go
update tbl_satis set kart_id='4' where kart_id=3
go
update tbl_Uye set uye_ad='Muhittin' where uye_ıd>9 OR uye_ad like 'M%'
go
update tbl_muze set muze_İlceFK='4' where muze_Id between 8 and 10
go
/*Fonsiyonlar*/
select avg(kart_fiyat) from tbl_kart
go
select sum(kart_fiyat) from tbl_kart
go
select max(kart_fiyat) from tbl_kart
go
select min(kart_fiyat) from tbl_kart
go
select count(kart_fiyat) from tbl_kart /*Kaçtane Adet Fiyat Var*/
go
select upper(uye_ad) from Tbl_Uye
go
select lower(uye_adres) from tbl_Uye
go
select len(uye_ad) from Tbl_uye
go