Re: SQL Error (1064): You have an error in your SQL syntax.

[Clive Wightman]

Have managed to fix the table issue removed the charset..

But now when trying to create the Trigger I get.

/* SQL Error (1064): You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'TRIGGER `URSAUDIT_UPD` AFTER UPDATE

ON `swanalysts`


F */
/*



help please


use sw_systemdb ;

DELIMITER //

CREATE
TRIGGER `URSAUDIT_UPD` AFTER UPDATE

ON `swanalysts`


FOR EACH ROW BEGIN


INSERT INTO AUDIT (analystid, changeby, fullname, modificationmade, changetype)

values ( old.analystid, user(), old.name, new.name, 'UPDATE') ;

END ;

//



DELIMITER ;