Documentation Home
MySQL 9.2 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 40.5Mb
PDF (A4) - 40.6Mb
Man Pages (TGZ) - 259.6Kb
Man Pages (Zip) - 366.8Kb
Info (Gzip) - 4.1Mb
Info (Zip) - 4.1Mb


27.3.6.10 MySQL Functions

The following SQL built-in functions are supported in MySQL 9.2 and later, and can be called directly from the mysql namespace. These are described in the following list, along with their analogous SQL functions:

  • rand() (MySQL RAND()): Returns a random floating-point value v in the range 0 <= v < 1.0.

  • sleep(seconds) (MySQL SLEEP()): Pauses for seconds seconds, then returns 0.

  • uuid() (MySQL UUID()): Returns a Universal Unique Identifier (UUID).

  • isUUID(argument) (MySQL IS_UUID()): Returns 1 if the argument is a valid string-format UUID, 0 if it is not a valid UUID, and NULL if the argument is NULL.