PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/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/doc/refman/8.0/en/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/doc/refman/8.0/en/spatial-geojson-functions.html
max_dec_digits, if specified, limits the number of decimal digits for coordinates and causes rounding of output. This section describes functions for converting between GeoJSON documents and spatial values. Feature and FeatureCollection objects are ...
https://dev.mysql.com/doc/refman/8.0/en/trigger-syntax.html
To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 15.1.22, “CREATE TRIGGER Statement”, and Section 15.1.34, “DROP TRIGGER Statement”. Here is a simple example that associates a ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-trace-statement-digest.html
in_interval DECIMAL(2,2): The analysis interval in seconds (which can be fractional) at which to try to take snapshots. Traces all Performance Schema instrumentation for a specific statement digest. If you find a statement of interest within the ...
https://dev.mysql.com/doc/refman/8.0/en/known-issues.html
When inserting a big integer value (between 263 and 264−1) into a decimal or string column, it is inserted as a negative value because the number is evaluated in signed integer context. This section lists known issues in recent versions of MySQL.
https://dev.mysql.com/doc/refman/8.0/en/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 replica server uses for connecting to ...
https://dev.mysql.com/doc/refman/8.0/en/change-replication-source-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 REPLICATION SOURCE TO changes the parameters that the replica server uses for ...
https://dev.mysql.com/doc/refman/8.0/en/check-table.html
The storage method of the new DECIMAL data type changed between MySQL 5.0.3 and 5.0.5. option: { FOR UPGRADE | QUICK | FAST | MEDIUM | EXTENDED | CHANGED } CHECK TABLE checks a table or tables for errors. CHECK TABLE can also check views for ...
https://dev.mysql.com/doc/refman/8.0/en/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.