Search Results
https://dev.mysql.com/doc/refman/8.4/en/binary-log-setting.html
You can select the binary logging format explicitly by starting the MySQL server with --binlog-format=type. In MySQL 8.4, binary logging is enabled by default, and is disabled only if you start the server with --skip-log-bin or --disable-log-bin.
https://dev.mysql.com/doc/refman/8.4/en/charset-collation-coercibility.html
In the great majority of statements, it is obvious what collation MySQL uses to resolve a comparison operation. What collation should the result have? To resolve questions like these, MySQL checks whether the collation of one item can be coerced to ...For example, in the following cases, it should be clear that the collation is the collation of column x: SELECT x FROM T ORDER BY x; SELECT x FROM T WHERE x = x; SELECT DISTINCT x FROM T; However, with multiple operands, there can be ...
https://dev.mysql.com/doc/refman/8.4/en/check-table.html
Checking Version Compatibility The FOR UPGRADE option checks whether the named tables are compatible with the current version of MySQL. FOR UPGRADE discovers these incompatibilities: The indexing order for end-space in TEXT columns for InnoDB and ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-secondary-indexes.html
row *************************** id: 1 select_type: SIMPLE table: jemp partitions: NULL type: range possible_keys: i key: i key_len: 5 ref: NULL rows: 2 filtered: 100.00 Extra: Using where 1 row in set, 1 warning (0.00 sec) mysql> SHOW WARNINGS\G ...
https://dev.mysql.com/doc/refman/8.4/en/declare-handler.html
statement handler_action: { CONTINUE | EXIT | UNDO } condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value | condition_name | SQLWARNING | NOT FOUND | SQLEXCEPTION } The DECLARE ... It can take the following forms: mysql_error_code: ...HANDLER statement specifies a handler that deals with one or more ...
https://dev.mysql.com/doc/refman/8.4/en/derived-tables.html
This is also true of the following nested SELECT: mysql> EXPLAIN SELECT NOW() AS a1, (SELECT f1(5)) AS a2\G *************************** 1. For information about lateral derived tables preceded by the LATERAL keyword, see Section 15.2.15.9, ...
https://dev.mysql.com/doc/refman/8.4/en/event-scheduler.html
The MySQL Event Scheduler manages the scheduling and execution of events, that is, tasks that run according to a schedule. The following discussion covers the Event Scheduler and is divided into the following sections: Section 27.4.1, “Event ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-stopwords.html
In a MySQL source distribution, you can find this list in the storage/myisam/ft_static.c file. The stopword list is loaded and searched for full-text queries using the server character set and collation (the values of the character_set_server and ...
https://dev.mysql.com/doc/refman/8.4/en/gis-general-property-functions.html
mysql> SELECT ST_Dimension(ST_GeomFromText('LineString(1 1,2 2)')); +------------------------------------------------------+ | ST_Dimension(ST_GeomFromText('LineString(1 1,2 2)')) | +------------------------------------------------------+ | 1 | ...
https://dev.mysql.com/doc/refman/8.4/en/gis-point-property-functions.html
mysql> SELECT ST_Y(Point(56.7, 53.34)); +--------------------------+ | ST_Y(Point(56.7, 53.34)) | +--------------------------+ | 53.34 | +--------------------------+ mysql> SELECT ST_AsText(ST_Y(Point(56.7, 53.34), 10.5)); ... A Point consists of X ...