Rechercher dans le manuel MySQL

Displaying 71 to 80 of 84 total results
https://dev.mysql.com/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Reserved words are permitted as ...
https://dev.mysql.com/time.html
The only delimiter recognized between a time part and a fractional seconds part is the decimal point. MySQL retrieves and displays TIME values in 'hh:mm:ss' format (or 'hhh:mm:ss' format for large hours values). The hours part may be so large ...
https://dev.mysql.com/trigger-syntax.html
To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 13.1.22, “CREATE TRIGGER Statement”, and Section 13.1.34, “DROP TRIGGER Statement”. Here is a simple example that associates a ...
https://dev.mysql.com/locale-support.html
The lc_time_names value does not affect the result from FORMAT(), but this function takes an optional third parameter that enables a locale to be specified to be used for the result number's decimal point, thousands separator, and grouping between ... The locale indicated by the lc_time_names system variable controls the language used to display day and month names and ...
https://dev.mysql.com/innodb-columns-table.html
1 = VARCHAR, 2 = CHAR, 3 = FIXBINARY, 4 = BINARY, 5 = BLOB, 6 = INT, 7 = SYS_CHILD, 8 = SYS, 9 = FLOAT, 10 = DOUBLE, 11 = DECIMAL, 12 = VARMYSQL, 13 = MYSQL, 14 = GEOMETRY. For related usage information and examples, see Section 15.15.3, “InnoDB ...
https://dev.mysql.com/c-api-prepared-statement-type-codes.html
The buffer_type member of MYSQL_BIND structures indicates the data type of the C language variable bound to a statement parameter or result set column. For input, buffer_type indicates the type of the variable containing the value to be sent to the ...
https://dev.mysql.com/regexp.html
This section discusses the functions and operators available for regular expression matching and illustrates, with examples, some of the special characters and constructs that can be used for regular expression operations. MySQL implements regular ...
https://dev.mysql.com/environment-variables.html
For example, setting UMASK=0600 is equivalent to UMASK=384 because 0600 octal is 384 decimal. This section lists environment variables that are used directly or indirectly by MySQL. Most of these can also be found in other places in this manual.
https://dev.mysql.com/change-master-to.html
The heartbeat interval interval is a decimal value having the range 0 to 4294967 seconds and a resolution in milliseconds; the smallest nonzero value is 0.001. ] CHANGE MASTER TO changes the parameters that the slave server uses for connecting to ...
https://dev.mysql.com/miscellaneous-functions.html
The return value is a utf8 string of five hexadecimal numbers separated by dashes. mysql> UPDATE t SET i = DEFAULT(i)+1 WHERE id < 100; FORMAT(X,D) Formats the number X to a format like '#,###,###.##', rounded to D decimal places, and returns the ...
Displaying 71 to 80 of 84 total results

Find a PHP function

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-decimal-p-8.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

  1. View the html document Language of the document:en Manuel MySQL : https://dev.mysql.com/

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.

Contents Haut