mysql - Create trigger error: invalid syntax

Question

SQL query:

CREATE TRIGGER tg_newuser_insert
BEFORE INSERT ON tbl_newuser
FOR EACH ROW
BEGIN
  INSERT INTO tbl_seq VALUES (NULL)
  SET NEW.id = CONCAT('YTUM', LPAD(LAST_INSERT_ID(), 8, '00000'));
END

MySQL said: Documentation
#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 'SET NEW.id = CONCAT('YTUM', LPAD(LAST_INSERT_ID(), 8, '00000')); END' at line 6

Answer 1

Your Formatting is off, remember DELIMITER $$ statements are required, as it is no different than creating a stored procedure.

Check the documentation any time you run into issues like this.

Scroll about half way down the documents to see the example.

But, This is what your looking for:

DELIMITER $$
CREATE TRIGGER tg_newuser_insert 
BEFORE UPDATE ON tbl_newuser
FOR EACH ROW
    BEGIN

        SET NEW.id = CONCAT('YTUM', LPAD(LAST_INSERT_ID(), 8, '00000'));

    END $$
DELIMITER ;