Untitled

mail@pastecode.io avatar
unknown
plain_text
3 months ago
523 B
3
Indexable
Never
create table std_add(
roll_no int primary key, 
name varchar(20),
address varchar(20),
place int,
pin int,
);

create table std_marks(
roll_no int references std_add on delete cascade,
subject varchar(20),
Exam_date date,
marks int
);

insert into std_add
values
(1,'Ram','KTM',1,21),
(2,'Sita','KTM',3,22),
(3,'Hari','KTM',2,23)

insert into std_marks
values
(1,'maths i','2024/3/4',34),
(2,'science','2024/3/4',45),
(3,'maths ii','2024/3/4',43)

select * from std_add
select * from std_marks
Leave a Comment