MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 241 to 250 of 253 total results

15.2.15.1 The Subquery as Scalar Operand

https://dev.mysql.com/doc/refman/9.7/en/scalar-subqueries.html

For example, LIMIT requires literal integer arguments, and LOAD DATA requires a literal string file name. In its simplest form, a subquery is a scalar subquery that returns a single value. A scalar subquery is a simple operand, and you can use it ...

15.7.7.24 SHOW INDEX Statement

https://dev.mysql.com/doc/refman/9.7/en/show-index.html

Cardinality is counted based on statistics stored as integers, so the value is not necessarily exact even for small tables. SHOW [EXTENDED] {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr] SHOW INDEX returns table ...

14.16.12 Spatial Aggregate Functions

https://dev.mysql.com/doc/refman/9.7/en/spatial-aggregate-functions.html

MySQL supports aggregate functions that perform a calculation on a set of values. For general information about these functions, see Section 14.19.1, “Aggregate Function Descriptions”. ST_Collect() can be used as a window function, as signified ...

14.16.2 Argument Handling by Spatial Functions

https://dev.mysql.com/doc/refman/9.7/en/spatial-function-argument-handling.html

In MySQL, the SRID value is an integer associated with the geometry value. Spatial values, or geometries, have the properties described in Section 13.4.2.2, “Geometry Class”. Specific functions or groups of functions may have additional or ...

14.16.11 Spatial GeoJSON Functions

https://dev.mysql.com/doc/refman/9.7/en/spatial-geojson-functions.html

The srid argument, if given, must be a 32-bit unsigned integer. This section describes functions for converting between GeoJSON documents and spatial values. Feature and FeatureCollection objects are not supported, except that geometry objects are ...

27.3.6.8 Warning Object

https://dev.mysql.com/doc/refman/9.7/en/srjsapi-warning.html

Warning represents a warning raised by statement execution, and has the following properties: code: MySQL error code (integer). Can be any one of 1 (NOTE), 2 (WARNING), or 3 (ERROR). You can also employ the JavaScript Error object, such as obtained ...

35.4.3 Server Metrics

https://dev.mysql.com/doc/refman/9.7/en/telemetry-metrics-meter-metrics.html

These metrics are of OTEL Type ASYNC COUNTER and record the number of times (INTEGER) the corresponding command statement has been executed. The following server metrics are registered by default: mysql.stats Metrics mysql.stats.com Metrics ...

35.4.2 Server Meters

https://dev.mysql.com/doc/refman/9.7/en/telemetry-metrics-meters.html

To enable, or disable, a meter, or alter the meter frequency, use the following commandline parameter syntax: --performance-schema-meter='meterName=frequency:integer,enabled:ON|OFF' The following example enables the mysql.inno meter and sets the ...

11.4 User-Defined Variables

https://dev.mysql.com/doc/refman/9.7/en/user-variables.html

User variables can be assigned a value from a limited set of data types: integer, decimal, floating-point, binary or nonbinary string, or NULL value. You can store a value in a user-defined variable in one statement and refer to it later in another ...

B.3.4.2 Problems Using DATE Columns

https://dev.mysql.com/doc/refman/9.7/en/using-date.html

When you compare a DATE, TIME, DATETIME, or TIMESTAMP to a constant string with the <, <=, =, >=, >, or BETWEEN operators, MySQL normally converts the string to an internal long integer for faster comparison (and also for a bit more “relaxed” ...

Displaying 241 to 250 of 253 total results