Untitled

 avatar
unknown
plain_text
3 years ago
697 B
5
Indexable
drop table result;
drop table students;

create table students(name varchar(60), marks int);
create table result(name varchar(60), class varchar(20));


alter table students add primary key (name);
alter table result add foreign key (name) references students(name);

insert into students values('Ruturaj', 1300);
insert into students values('Tanmya', 830);
insert into students values('Tanish', 930);

drop procedure grade;

delimiter @@
create procedure grade(
	in sname varchar(20)
)
begin 

	declare res int;
	
	select marks,name  into cmarks,cname from students where cname=name and sroll=roll_no;
	
	if cmarks <= 1500 and cmarks >= 990 then
		insert into result values(cname, 'Distinction');
Editor is loading...