Untitled
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...