MySqli php UUID_SHORT

Question

Basically what I want to do is to use MySqli to just do a query UUID_SHORT() and get the result. No INSERT,UPDATE,DELETE or anything, I just want the value of UUID_SHORT.

Haven't been able to figure it out, any help would be great!

Thanks.

Answer 1

How about SELECT UUID_SHORT();

There is more information in the MySQL documentation.

Example:

function UUID_SHORT(mysqli $db)
{
    $result = $db->query("SELECT UUID_SHORT();");
    $res = $result->fetch_array();
    return $res[0];
}