Using large concat in query issues

[ericatekka]

Hello,

Trying to create some triggers so capture some additional auditing information.

Here is my code

CREATE TRIGGER DEL_PORTALMEMBERS_ARCH_B BEFORE UPDATE ON portalmembers

FOR EACH ROW

BEGIN

  INSERT INTO GENERAL_MESSAGES (`MOD_ID`,`CONTENT`,`REFERENCE`) VALUES(1000, CONCAT('TMID:',OLD.`nick_name`,'|First:',OLD.`first_name`,'|Last:',OLD.`last_name`,'|Email:',OLD.`email`,'|Access:',OLD.`access`,'|Group:',OLD.`group`,'|TMLEADER:',OLD.`teamleaderNUM`),OLD.`nick_name`);

END;

Unless someone can find a way to convert the row into XML the way above is the preferred way. My account has Super Privileges.