19 - MySQL between kullanımı

Опубликовано: 24 Март 2026
на канале: Logic of Computer

183

MySQL between kullanımı
drop table if exists ogrenciler;
create table if not exists ogrenciler (
id int primary key auto_increment,
ogr_no char(10) unique not null,
adi varchar(40),
sinif varchar(5),
sehir varchar(20),
note int
) ;

insert ogrenciler (ogr_no, adi, sinif, sehir, note) values
('220120','Seyma','3A','Malatya',66),('220121','Selma','3A','Hatay',65), ('220122','Kamil','3A','Kastamonu',55),
('230120','Salih','3A','İzmir',50), ('230121','Hatice','3A','Hatay',86), ('230122','Halim','3A','Adana',60),
('231120','Melih','3B','Adana',40), ('231121','Ömer' ,'3A','Hatay',97), ('231122','Faruk','3B','Malatya',70),
('232120','Melih','3B','Adana',35), ('232121','Berke' ,'3A','Adana',85), ('232122','Kazım','3B','Adana',80),
('231100','Sevda','3B','Hatay',45), ('231521','Ömer' ,'3A','Hatay',75), ('231522','Sevil','3B','Malatya',90);