https://dev.mysql.com/date-and-time-functions.html
CURDATE() Returns the current date as a value in 'YYYY-MM-DD' or YYYYMMDD format, depending on whether the function is used in a string or numeric context. CURTIME([fsp]) Returns the current time as a value in 'hh:mm:ss' or hhmmss format, depending ... This section describes the functions that can be used to manipulate temporal ...
https://dev.mysql.com/miscellaneous-functions.html
INET_ATON(expr) Given the dotted-quad representation of an IPv4 network address as a string, returns an integer that represents the numeric value of the address in network byte order (big endian). INET_NTOA(expr) Given a numeric IPv4 network address ...The function return value and type are the same as the return value and type of its argument, but the function result is not checked for the ONLY_FULL_GROUP_BY SQL ...
https://dev.mysql.com/group-by-functions.html
For numeric arguments, the variance and standard deviation functions return a DOUBLE value. (They convert the values to numbers, losing everything after the first nonnumeric character.) To work around this problem, convert to numeric units, perform ... This section describes group (aggregate) functions that operate on sets of ...
https://dev.mysql.com/innodb-memcached-porting-mysql.html
If there is a short numeric primary key column in an InnoDB table, use it as the unique lookup key for memcached by converting the integer to a string value. For example, prepend the table name, or the database name and the table name, before the ...
https://dev.mysql.com/innodb-parameters.html
System variables that take a numeric value can be specified as --var_name=value on the command line or as var_name=value in option files. --innodb[=value] Property Value Command-Line Format --innodb[=value] Deprecated Yes Type Enumeration Default ...
https://dev.mysql.com/bit-value-literals.html
In numeric contexts, MySQL treats a bit literal like an integer. To ensure numeric treatment of a bit literal, use it in numeric context. To convert a bit value to printable form, use it in numeric context or use a conversion function such as BIN() ...A leading 0b is case sensitive and cannot be written as ...
https://dev.mysql.com/dynamic-system-variables.html
Variables that have a type of “numeric” take a numeric value. Variables that are marked as “enumeration” normally should be set to one of the available values for the variable, but can also be set to the number that corresponds to the ...
https://dev.mysql.com/enum.html
An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation time. and these potential issues to consider: If you make enumeration values that look like ...It has these advantages: Compact data storage in situations where a column has a limited set of possible ...
https://dev.mysql.com/server-system-variables.html
completion_type Property Value Command-Line Format --completion-type=# System Variable completion_type Scope Global, Session Dynamic Yes SET_VAR Hint Applies No Type Enumeration Default Value NO_CHAIN Valid Values NO_CHAINCHAINRELEASE012 The ... The ...
https://dev.mysql.com/c-api-data-structures.html
You can use the IS_NUM() macro to test whether a field has a numeric type. Pass the type value to IS_NUM() and it evaluates to TRUE if the field is numeric: if (IS_NUM(field->type)) printf("Field is numeric\n"); ENUM and SET values are returned as ... This section describes C API data structures other than those used for prepared statements, the asychronous interface, or the replication stream ...
