MySQL Tutorial Miscellaneous Functions 12 codes

1 DEFAULT(col_name)

2 GET_LOCK(str,timeout)

3 INET_ATON() also understands short-form IP addresses

4 INET_ATON(expr)

5 INET_NTOA(expr) does the opposite for INET_ATON

6 IS_FREE_LOCK(str)

7 IS_USED_LOCK(str)

8 Miscellaneous Functions

9 RELEASE_LOCK(str)

10 SLEEP(duration)

11 UUID() returns a number that is globally unique in space and time

12 VALUES(col_name)