Search Results
https://dev.mysql.com/doc/refman/8.4/en/populating-spatial-columns.html
After you have created spatial columns, you can populate them with spatial data. Values should be stored in internal geometry format, but you can convert them to that format from either Well-Known Text (WKT) or Well-Known Binary (WKB) format. For ...
https://dev.mysql.com/doc/refman/8.4/en/precision-math-rounding.html
This section discusses precision math rounding for the ROUND() function and for inserts into columns with exact-value types (DECIMAL and integer). The ROUND() function rounds differently depending on whether its argument is exact or approximate: ...
https://dev.mysql.com/doc/refman/8.4/en/privilege-checking.html
In complex scenarios where the query uses SQL SECURITY DEFINER views or stored routines, it may be that a user is denied from seeing the trace of its query because it lacks some extra privileges on those objects. In that case, the trace will be ...
https://dev.mysql.com/doc/refman/8.4/en/problems-connecting.html
If you encounter problems when you try to connect to the MySQL server, the following items describe some courses of action you can take to correct the problem. To correct this when you invoke a client program, specify a --port option to indicate ...
https://dev.mysql.com/doc/refman/8.4/en/repeat.html
[begin_label:] REPEAT statement_list UNTIL search_condition END REPEAT [end_label] The statement list within a REPEAT statement is repeated until the search_condition expression is true. statement_list consists of one or more statements, each ...
https://dev.mysql.com/doc/refman/8.4/en/replication-multi-source-monitoring.html
This enables you to write complex queries based on Channel_Name as a key. To monitor the status of replication channels the following options exist: Using the replication Performance Schema tables. By default, if the FOR CHANNEL channel clause is ...
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks.html
(An exception is USER_VAR events that are associated with DDL queries, which are executed.) It does not execute any statements that are logged within DML transactions. By default, MySQL replication (including Group Replication) does not carry out ...
https://dev.mysql.com/doc/refman/8.4/en/replication-rules-table-options.html
The replica checks for and evaluates table options only if either of the following two conditions is true: No matching database options were found. One or more database options were found, and were evaluated to arrive at an “execute” condition ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-rbr-monitoring.html
For example to get progress for update events issue: mysql> SELECT WORK_COMPLETED, WORK_ESTIMATED FROM performance_schema.events_stages_current -> WHERE EVENT_NAME LIKE 'stage/sql/Applying batch of row changes (update)' If ... The current progress ...
https://dev.mysql.com/doc/refman/8.4/en/security-plugins.html
MySQL includes several components and plugins that implement security features: Plugins for authenticating attempts by clients to connect to MySQL Server. For general discussion of the authentication process, see Section 8.2.17, “Pluggable ...