MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 281 to 289 of 289 total results

« Previous
27
28
29
Next »

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

This section describes functions for converting between GeoJSON documents and spatial values. Feature and FeatureCollection objects are not supported, except that geometry objects are extracted from them. MySQL also supports a native JSON data type ...

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

The following server metrics are registered by default: mysql.stats Metrics mysql.stats.com Metrics mysql.stats.connection Metrics mysql.perf_schema Metrics mysql.stats.handler Metrics mysql.stats.myisam Metrics mysql.stats.ssl Metrics mysql.inno ...

35.4.2 Server Meters

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

For example, to update the frequency of the mysql.inno metrics: mysql>update performance_schema.setup_meters set FREQUENCY='30' where name = 'mysql.inno'; The maximum number of meter instruments which can be created is set by ...

11.4 User-Defined Variables

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

You can store a value in a user-defined variable in one statement and refer to it later in another statement. This enables you to pass values from one statement to another. User variables are written as @var_name, where the variable name var_name ...

B.3.4.2 Problems Using DATE Columns

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

You should use this format in UPDATE expressions and in the WHERE clause of SELECT statements. For example: SELECT * FROM t1 WHERE date >= '2003-05-05'; As a convenience, MySQL automatically converts a date to a number if the date is used in numeric ...

8.4.4 The Password Validation Component

https://dev.mysql.com/doc/refman/9.7/en/validate-password.html

The validate_password component serves to improve security by requiring account passwords and enabling strength testing of potential passwords. This component exposes system variables that enable you to configure password policy, and status ...

22.5.5 Connection Compression with X Plugin

https://dev.mysql.com/doc/refman/9.7/en/x-plugin-connection-compression.html

X Plugin supports compression of messages sent over X Protocol connections. Connections can be compressed if the server and the client agree on a mutually supported compression algorithm. Enabling compression reduces the number of bytes sent over ...

15.3.8.1 XA Transaction SQL Statements

https://dev.mysql.com/doc/refman/9.7/en/xa-statements.html

To perform XA transactions in MySQL, use the following statements: XA {START|BEGIN} xid [JOIN|RESUME] XA END xid [SUSPEND [FOR MIGRATE]] XA PREPARE xid XA COMMIT xid [ONE PHASE] XA ROLLBACK xid XA RECOVER [CONVERT XID] For XA START, the JOIN and ...