Rechercher dans le manuel MySQL
Search Results
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 ...
Document created the 26/06/2006, last modified the 26/10/2018
Source of the printed document:https://www.gaudry.be/en/mysql-rf-fct-numeric-p-2.html
The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.
References
These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.
