PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/spatial-relation-functions-object-shapes.html
mysql> SET @g1 = ST_GeomFromText('Polygon((0 0,0 3,3 3,3 0,0 0))'), -> @p1 = ST_GeomFromText('Point(1 1)'), -> @p2 = ST_GeomFromText('Point(3 3)'), -> @p3 = ST_GeomFromText('Point(5 5)'); Query OK, 0 rows affected (0.00 sec) mysql> SELECT -> ... The ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log-formats.html
In row-based logging (the default), the source writes events to the binary log that indicate how individual table rows are affected. You can cause the server to use row-based logging by starting it with --binlog-format=ROW. With mixed logging, ...
https://dev.mysql.com/doc/refman/8.0/en/data-type-defaults.html
When binlog_format is set to MIXED or ROW, the statement is executed as normal. For nontransactional tables, an error occurs, but if this happens for the second or subsequent row of a multiple-row statement, the preceding rows are inserted. Suppose ... Data type specifications can have explicit or implicit default ...
https://dev.mysql.com/doc/refman/8.0/en/declare-handler.html
If no more rows are available, a No Data condition occurs with SQLSTATE value '02000'. statement handler_action: { CONTINUE | EXIT | UNDO } condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value | condition_name | SQLWARNING | NOT ...
https://dev.mysql.com/doc/refman/8.0/en/events-privileges.html
However, e_insert continues to execute, inserting a new row into mytable each seven seconds. For a schema-level EVENT privilege, GRANT creates a row in mysql.db and sets that row's Db column to the name of the schema, the User column to the name of ... To enable or disable the execution of scheduled events, it is necessary to set the value of the global event_scheduler system ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-optimization.html
Some INFORMATION_SCHEMA tables contain columns that provide table statistics: STATISTICS.CARDINALITY TABLES.AUTO_INCREMENT TABLES.AVG_ROW_LENGTH TABLES.CHECKSUM TABLES.CHECK_TIME TABLES.CREATE_TIME TABLES.DATA_FREE TABLES.DATA_LENGTH ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-triggers-table.html
The value is INSERT (a row was inserted), DELETE (a row was deleted), or UPDATE (a row was modified). The ACTION_REFERENCE_OLD_ROW value is always OLD and the ACTION_REFERENCE_NEW_ROW value is always NEW. To see information about a table's triggers, ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-transactions.html
That blocking lock request is for a row or table lock held by another transaction in an incompatible mode. For every blocked transaction, data_locks contains one row that describes each lock the transaction has requested, and for which it is waiting. This table contains one or more rows for each blocked transaction, indicating the lock it has requested and any locks that are blocking that ... Note This section describes locking information as exposed by the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-example-data.html
Note The information in this section applies to NDB Cluster running on both Unix and Windows platforms. Working with database tables and data in NDB Cluster is not much different from doing so in standard MySQL. There are two key points to keep in ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-mysqld.html
You should see the value YES as the Support value in the row for NDBCLUSTER. If you see NO in this row or if there is no such row displayed in the output, you are not running an NDB-enabled version of MySQL. If you see DISABLED in this row, you need ...To be used with NDB Cluster, mysqld needs to be built with support for the NDB storage engine, as it is in the precompiled binaries available from ...