In SQLite, ABS() is a built-in scalar function that returns the absolute value of its argument.
The absolute value is the non-negative equivalent of the argument. It can be thought of as the distance from zero that the number resides on the number line, without considering direction.
In MySQL, VERSION() is a built-in function that returns the MySQL server version.
The result is a string that uses the utf8mb3 character set. A suffix may also be appended to the version number indicating server build or configuration information.
The following table contains a full list of format specifiers that can be used in format strings with functions like DATE_FORMAT(), STR_TO_DATE(), and FROM_UNIXTIME() in MySQL.
In MySQL, CURRENT_USER() is a built-in function that returns the user name and host name combination for the MySQL account that the server used to authenticate the current client.
In MySQL, USER() is a built-in function that returns the current MySQL user name and host name, given when connecting to MySQL.
The result is returned as a string in the utf8mb3 character set.
The value returned by USER() could be different to the value returned by CURRENT_USER().
In Redis, the ZMSCORE command allows us to get the score of one or members in a sorted set.
In Redis, the ZSCORE command returns the score of the specified member of a sorted set.