Rechercher dans le manuel MySQL
Search Results
https://dev.mysql.com/alter-table.html
The exception referred to earlier is that ALTER TABLE blocks reads (not just writes) at the point where it is ready to clear outdated table structures from the table and table definition caches. ALTER TABLE tbl_name [alter_specification [, ...
https://dev.mysql.com/audit-log-logging-configuration.html
(At this point, encrypted log files that have a suffix of .enc rather than .pwd_id.enc become unreadable by the plugin, so it is assumed that you no longer need them.) The audit log file has the potential to grow very large and consume a lot of disk ... This section describes how to configure audit logging characteristics, such as the file to which the audit log plugin writes events, the format of written events, and whether to enable log file compression and ...
https://dev.mysql.com/backup-methods.html
The binary log files provide you with the information you need to replicate changes to the database that are made subsequent to the point at which you performed a backup. These binary logs are the incremental backup; at restore time, you apply them ...Making a Hot Backup with MySQL Enterprise Backup Customers of MySQL Enterprise Edition can use the MySQL Enterprise Backup product to do physical backups of entire instances or selected databases, tables, or ...
https://dev.mysql.com/backup-policy.html
A full backup (a snapshot of the data at a point in time) can be done in MySQL with several tools. For example, MySQL Enterprise Backup can perform a physical backup of an entire instance, with optimizations to minimize overhead and avoid disruption ...
https://dev.mysql.com/change-master-to.html
When you restart the replication channel, the privilege checks are applied from that point on. ] CHANGE MASTER TO changes the parameters that the slave server uses for connecting to the master server, for reading the master binary log, and reading ...
https://dev.mysql.com/choosing-types.html
For high precision, you can always convert to a fixed-point type stored in a BIGINT. This enables you to do all calculations with 64-bit integers and then convert results back to floating-point values as necessary. For optimum storage, you should ...
https://dev.mysql.com/control-flow-functions.html
If expr2 or expr3 produce a floating-point value, the result is a floating-point value. The second syntax returns the result for the first condition that is true. If no comparison or condition is true, the result after ELSE is returned, or NULL if ...
https://dev.mysql.com/create-spatial-reference-system.html
srs_attribute: { NAME 'srs_name' | DEFINITION 'definition' | ORGANIZATION 'org_name' IDENTIFIED BY org_id | DESCRIPTION 'description' } srid, org_id: 32-bit unsigned integer This statement creates a spatial reference system (SRS) definition and ...
https://dev.mysql.com/datetime.html
The fractional part should always be separated from the rest of the time by a decimal point; no other fractional seconds delimiter is recognized. The only delimiter recognized between a date and time part and a fractional seconds part is the decimal ...This section describes their characteristics, how they are similar, and how they ...
https://dev.mysql.com/gis-class-geometry.html
Geometry values of types (LineString, MultiPoint, MultiLineString) are either simple or nonsimple. Whether the value is empty or nonempty A geometry is empty if it does not have any points. The dimensions of MultiPoint, MultiLineString, and ...It is ...
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-point-p-10.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.
