Do you want nested IF
statements?
BEGIN
IF NEW.visibility = 1
IF NEW.item_type = 'propal' THEN
INSERT INTO anas01_propal . . . ;
ELSEIF NEW.item_type = 'facture' THEN
INSERT INTO anas01_facture . . l;
END IF;
END IF;
END;
Note: Your INSERT
s are incomplete. Add the columns and values where the . . .
are.
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…