Ive built a trigger for inserting a new user, but when I try and run the SQL Query I get:-
#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 '' at line 4.
Any ideas What Im doing wrong?
Table is called `users` and there is a coloum called `priID` set to a VARCHAR(255) [Im going to reduce this though!]
Any help, would be appriciated.
CREATE TRIGGER users_insert BEFORE INSERT ON `users`
FOR EACH ROW
SET NEW.`priID` = UUID();