troubleshooting Question

Creating a function to remove - from uuid

Avatar of tonelm54
tonelm54 asked on
MySQL ServerSQL
1 Comment1 Solution411 ViewsLast Modified:
Good evening,
Ive been playing around with a function, which removes the - from the uuid() statment.

delimiter //
CREATE FUNCTION uuid2()
RETURNS STRING
DETERMINISTIC
BEGIN
DECLARE strUUID STRING;
SET strUUID = REPLACE(uuid(),"-","");
return strUUID;
END//
delimiter ;

Open in new window


And then call it like
select uuid2();

However everytime I try the above code I get an error similar to:-
ERROR: Unknown Punctuation String @ 11
STR: //
SQL: delimiter //

Any suggestions on what Ive messed up with would be appriciated!

Thank you


Select uuid2();
ASKER CERTIFIED SOLUTION
sshah254

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros