0

I use the following code to generate a uuid concat with CMRC
it works fine uuid is generated in lower case i.e. CMRC+someString in lower case

I could not find anything to resolve this i had to post this on here for help
how can I convert this generated uuid to caps or uppercase within trigger in mysql before insert?

BEGIN
INSERT INTO clients_seq VALUES (NULL);
SET NEW.cid = CONCAT('CMRC', LPAD(UUID(), 10, '0'));
END

2
Contributors
2
Replies
17
Views
3 Years
Discussion Span
Last Post by Ehsan_3
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.