how to create trigger

[iameet301]

Create table team(tid, country, totalmatch, win,loss). Insert 8 team detail. Create trigger to verify totalmatch is not 0. export data into csv file. Read file using reader object and print record with winning %age.

[iameet301]

[23bca300]

here you write a table name instead of trigger name . And also you using select case statement that is not necssary here.

[23BCA305]

why you write match is not

in trigger

[23bca274]

You can create trigger with the help of following syntax :

CREATE TRIGGER trigger_name AFTER | BEFORE INSERT | UPDATE | DELETE ON table_name FOR EACH ROW BEGIN -- Trigger logic here END;

@iameet301