PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/partitioning-limitations-functions.html
Each of these functions returns an integer only if it is passed an argument of an exact numeric type, such as one of the INT types or DECIMAL. This section discusses limitations in MySQL Partitioning relating specifically to functions used in ...
https://dev.mysql.com/doc/refman/9.7/en/window-function-optimization.html
For other types, inverse aggregation is safe; this includes DECIMAL, which permits a fractional part but is an exact-value type. Window functions affect the strategies the optimizer considers: Derived table merging for a subquery is disabled if the ...
https://dev.mysql.com/doc/refman/9.7/en/vector-functions.html
MySQL 9.7 supports SQL functions to work with VECTOR values. It accepts the following arguments: A column of VECTOR data type. STRING_TO_VECTOR(string) Converts a string representation of a vector to a binary one. The expected format of the string ...
https://dev.mysql.com/doc/refman/9.7/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.27, “CREATE TRIGGER Statement”, and Section 15.1.41, “DROP TRIGGER Statement”. Here is a simple example that associates a ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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/9.7/en/srjsapi-routines.html
Two functions, listed here, provide JavaScript Function objects reflecting MySQL stored routines: getFunction(): Get a Function instance given the name of a stored function. getProcedure(): Get a Function instance given the name of a stored ...
https://dev.mysql.com/doc/refman/9.7/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 ...