Re: update trigger to query before inserting into new database

[William Chiquito]

Hi William,

Try:

DELIMITER $$

DROP TRIGGER `addinventory `$$

CREATE TRIGGER `addinventory` AFTER UPDATE on `tracking`
FOR EACH ROW
BEGIN
	IF (NEW.tracking_status != OLD.tracking_status) THEN
		INSERT INTO test.trigger (shoppingcartid)
		SELECT DISTINCT trackitem.trackitem_itemnumber FROM trackitem
		INNER JOIN tracking ON trackitem.trackitem_tracknum = OLD.tracking_id;
	END IF;
END$$

DELIMITER ;