I am getting some bind variable errors for compname and lineno when trying to run this trigger with mysql. The trigger is going to delete a row from scores whenever was is delted from enrolls. I know that most bind errors come from some kind of error with the name not being in the schema, but I do not understand why I am getting this error for this. The schema for scores is sid varchar2(5) term varchar2(1) lineno number(4,0) compname(15) points number(4,0) create or replace TRIGGER enrolls_trigger AFTER DELETE ON ENROLLS FOR EACH ROW BEGIN DELETE FROM scores WHERE scores.sid= :old.sid AND scores.term = :old.term AND scores.lineno = :old.lineno AND scores.compname = :old.compname AND scores.points = :old.points; END;