CODEWITHSUNDEEP
mysqlsqltriggersinsertdolibarr
Anascode
Anascode

Reputation: 1

how to insert into another table with a trigger?

anas01_notesanas01_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

Upvotes: 0

Views: 381

Answers (1)

Gordon Linoff
Gordon Linoff

Reputation: 1270021

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.

Upvotes: 0

Related Questions