MySQL Forums
Forum List  »  General

UUID : Unique value or different ones ?
Posted by: Jean-Nicolas BERGER
Date: October 31, 2019 07:15AM

Hi,

When I execute
SELECT X,X as Y FROM (SELECT UUID() AS X) t;
I get the same value for both columns (X and Y)

But when I execute
SELECT X,X AS Y FROM (SELECT UUID() AS X FROM (SELECT 1 AS ZZ) z) t;
I still get one row but X and Y columns have different values.

Could someone explain it ?

Regards.
JN.

Options: ReplyQuote


Subject
Written By
Posted
UUID : Unique value or different ones ?
October 31, 2019 07:15AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.