how to insert into another table with a trigger?

Question

anas01_notes anas01_propalI will explain better because I was not very clear. I have 2 tables, the anas01_notes table in which there is a note_value field and another "visibility" field. The 2nd table which is anas01_propal has a field which is note_public. I want to create a trigger that makes sure that when my note has visibility at 1 then the content of note_value is inserted in the anas01_propal table in the note_public field.

`BEGIN
    IF NEW.visibility = 1
        ELSEIF NEW.item_type = "propal" THEN
            INSERT INTO anas01_propal
        ELSEIF NEW.item_type = "facture" THEN
            INSERT INTO anas01_facture
    END IF;
END`

MySQL a répondu : #1064 - Erreur de syntaxe près de 'ELSEIF NEW.item_type = "propal" THEN INSERT INTO anas01_propal ...' à la ligne 3

here be indulgent I begin please

Please check the syntax for insert commands in MySQL documentation [https://dev.mysql.com/doc/refman/8.0/en/insert.html]. Your insert queries seem to be incomplete — greenPadawan, Jan 22 '21 at 13:50

score 0 · Answer 1 · answered Jan 22 '21 at 13:15

0

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 INSERTs are incomplete. Add the columns and values where the . . . are.

answered Jan 22 '21 at 13:15

Gordon Linoff

1,242,037
58
646
786

I have to write all the columns of my table or just the one that is affected by the insertion? – Anascode Jan 22 '21 at 13:23
@Anascode . . . You have to write syntactically correct `insert` statements. Your question doesn't have enough information to specify what those are. – Gordon Linoff Jan 22 '21 at 14:25
@Anascode . . . That explanation belongs in the question, not in a comment. – Gordon Linoff Jan 25 '21 at 13:30

how to insert into another table with a trigger?

1 Answers1