Creating trigger in mysql for generation UUID

mysql

Solution

As mentioned by @mabi in the comments - you have a syntax error with the brackets. The following modified code works for me:

DELIMITER #
CREATE TRIGGER insert_guid 
BEFORE INSERT ON guid_tool
FOR EACH  ROW 
BEGIN 
    SET NEW.guid_key = UUID(); 
END;
#
DELIMITER ;

Testing it out:

mysql> INSERT INTO guid_tool (ID) VALUES (1);
Query OK, 1 row affected, 1 warning (0.04 sec)

mysql> SELECT * FROM guid_tool;
+----+--------------------------------------+
| ID | guid_key                             |
+----+--------------------------------------+
|  1 | a0467ebf-5c4f-11e3-903a-6cccbb4423e3 |
+----+--------------------------------------+
1 row in set (0.00 sec)

Problem

how can this throw an error when trying to create a trigger before insert in MySQL so that it generates new UUID for every input. ``` CREATE TRIGGER insert_guid BEFORE INSERT ON guid_tool (FOR EACH ROW BEGIN SET NEW.guid_key = UUID()); END; ``` and here is my table ``` create table guid_tool ( ID INT NOT NULL AUTO_INCREMENT, guid_key CHAR(40) NOT NULL, PRIMARY KEY(ID) ) CHARSET=LATIN1; ``` I must be doing something wrong.

Original source