Re: Error Code 2014 Commands out of sync; (MySQL WorkBench)

[Peter Brawley]

Three problems ...

DELIMITER $$
DROP TRIGGER IF EXISTS Before_Salary_Table_Delete; -- MOVE THIS LINE TO BEFORE THE DELIMITER DIRECTIVE 
CREATE TRIGGER Before_Salary_Table_Delete
BEFORE DELETE ON salaries FOR EACH ROW             -- DO NOT TERMNATE THIS LINE WITH A SEMICOLON
BEGIN
  SET @message = ‘This record was deleted’;        -- STRING HAS NON-ASCII CHARS THAT CONFUSE MYSQL
                                                   -- RETYPE THE LINE
  INSERT INTO SalaryLogAudit2( employeeNumber, validFrom, amount, ActionTaken )
  VALUES(OLD.employeeNumber,OLD.validFrom,OLD.amount,OLD.ActionTaken);
  UPDATE SalaryLogAudit2 
  SET ActionTaken = @message 
  WHERE employeenumber = OLD.employeeNumber;
END;
$$
DELIMITER ;

About the non-ascii chars, did you wrote this code WinWord or something like that? Don't do that.