Re: Create Primary Key with UUID()

[Peter Brawley]

DROP TABLE IF EXISTS t;
CREATE TABLE t(id CHAR(128));

DELIMITER //
CREATE TRIGGER init_uuid BEFORE INSERT ON t
  FOR EACH ROW SET NEW.id = UUID();
//
DELIMITER ;

INSERT INTO t VALUES( NULL );
SELECT * FROM t;
+--------------------------------------+
| id                                   |
+--------------------------------------+
| 42114800-6f22-1000-9611-2eb9174826e3 |
+--------------------------------------+

PB