Fill logbook table with an INSERT TRIGGER after saving in the table bagones

0

Create the trigger but when the insert is executed it gives the following error:

TRIGGER Code

DROP TRIGGER IF EXISTS 'bin_bagon_ins';
CREATE DEFINER = 'root'
@ 'localhost'
TRIGGER 'bin_bagon_ins'
AFTER INSERT ON 'bagon'
FOR EACH ROW INSERT INTO binnacle(user_id, bagon_id, created_at, active) VALUES(user_id(user), bagon_id(bagon), NOW(), active)

BAGON Table

BINNACLE Table (BITACORA)

    
asked by Julián Cordoba 12.09.2018 в 21:32
source

0 answers