select uid AS uid,
concat(
substring(uid, 25,2)
, ':', substring(uid, 27,2)
, ':', substring(uid, 29,2)
, ':', substring(uid, 31,2)
, ':', substring(uid, 33,2)
, ':', substring(uid, 35,2)
)
AS uuid_to_mac
FROM
(select uuid() uid)
AS alias;
select uid AS uid,
concat(
substring(uid, 25,2)
, ':', substring(uid, 27,2)
, ':', substring(uid, 29,2)
, ':', substring(uid, 31,2)
, ':', substring(uid, 33,2)
, ':', substring(uid, 35,2)
)
AS uuid_to_mac
FROM
(select uuid() uid)
AS alias;