Hey guys...I have a MySql table like this. and Grade column is a derived attribute. and it is based on Marks. u know the basic thing.
create table Enrolled( student_id char(14), subject_code varchar(10), marks int, grade char(2) );
I want to fill the Grade column based on each student's marks. I don't want to fill it by my self. Can I use a function or a procedure or something? How can I do this?
Tell me if i want to make my self more clear...ok..Thankx in advance!