MySql Triggers

[xiao-xiao]

---

since wala mn programming nga section diri... diri na lng nako i-post.

kanang kuan ba. kinsa kabalo sa inyo diri ug mysql triggers?

for example naa ko "subjects_enrolled" na table tapos some of it's attributes are subn_no(primary key), grade, remarks.

gusto nako nga automatic na ang remarks. for example ang grade kay 2.0 dapat automatic ang value sa remarks as "passed"... so dili na nako i-code sa php ang value sa remarks based sa grade.

[SmaRkieS]

Edit: aw MSSQL diay ni ayaw nalang ni.


--------------------------------------
sample trigger from my ran online private server, if new level 1 character created then the level will be change to 100.

CREATE TRIGGER [dbo].[NewChar_Level] ON [dbo].[ChaInfo]
after update
as
BEGIN

Update [ChaInfo] set [ChaInfo].ChaLevel=100
From Inserted
Where Inserted.ChaLevel = 1 and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].UserNum =inserted.UserNum

END

[vern]

There IS a programming section. You didn't look.

[xiao-xiao]

aw... sori.. wla ko kabantay nalibat ko. hehe.

[xiao-xiao]

murag gamitan mn ni ug mga "if" conditons akoa
1-3 = passed
INC = incomplete
--- = no grad yet

[xiao-xiao]

*bump* tabang mo please

[kolz]

create trigger setgrade after insert, update on subjects_enrolled
for each row
begin
if new.grade < 2 then
new.remarks = 'payter doh!'
elseif new.grade > 3 then
new.remarks = 'hangbong ka doh!'
...
end;

[xiao-xiao]

weee... salamat.. try daw nako

[xiao-xiao]

dili lage mugana... pati butngan nako ug delimiter ug end if... dili japon

[UtOkbOlinAO]

---CREATE TRIGGER SET_REMARKS
--- BEFORE INSERT ON SUBJECTS_ENROLLED
--- FOR EACH ROW
--- BEGIN
--- IF NEW.GRADE > 2.0 THEN
--- SET NEW.REMARKS = 'PASSED';
--- ELSE
--- SET NEW.REMARKS = 'FAILED';
--- END IF;
---END

try daw ni bai..