25 - MySQL Constraint (Foreign Key) kullanımı
use db01;
drop table if exists notlar; --
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)
) ;
insert ogrenciler (ogr_no, adi, sinif, sehir) values
('220120','Seyma','3A','İzmir'), ('220121','Selma' ,'3A','Hatay'), ('220122','Kamil','3A','İzmir'),
('230120','Salih','3A','İzmir'), ('230121','Hatice','3A','Hatay'), ('230122','Halim','3A','Adana'),
('231120','Melih','3B','Adana'), ('231121','Ömer' ,'3A','Hatay'), ('231122','Faruk','3B','İzmir'),
('232120','Melih','3B','Adana'), ('232121','Berke' ,'3A','Adana'), ('232122','Kazım','3B','Adana'),
('231100','Sevda','3B','Hatay'), ('231521','Ömer' ,'3A','Hatay'), ('231522','Sevil','3B','İzmir');
create table if not exists notlar (
ogr_id int,
ders varchar(20),
note int,
constraint fk_id foreign key (ogr_id) references ogrenciler(id)
);