Search Results
https://dev.mysql.com/doc/relnotes/mysql-monitor/8.0/en/news-8-0-32.html
Functionality Added or Changed Removed the integrated My Oracle Support (MOS) functionality. The MySQL server bundled with MySQL Enterprise Service Manager was upgraded from version 8.0.30 to 8.0.31. The bundled JRE was updated to 8u351.b10 for ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/collections-as-relational-tables.html
In this case a collection can be fetched as a Table object with the Schema.getCollectionAsTable() function. doc->'$.some.field.like[3].this' Once a collection has been fetched as a table with the Schema.getCollectionAsTable() function, all SQL CRUD ... Applications that seek to store standard SQL columns with Documents can cast a collection to a ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/collections-as-relational-tables.html
In this case a collection can be fetched as a Table object with the Schema.getCollectionAsTable() function. doc->'$.some.field.like[3].this' Once a collection has been fetched as a table with the Schema.getCollectionAsTable() function, all SQL CRUD ... Applications that seek to store standard SQL columns with Documents can cast a collection to a ...
https://dev.mysql.com/doc/refman/8.4/en/connection-access.html
The client supplies the credentials specified in the row (for example, a password), as indicated by the authentication_string column. The authentication method implemented by the plugin that authenticates the client may or may not use the password ... When you attempt to connect to a MySQL server, the server accepts or rejects the connection based on these conditions: Your identity and whether you can verify it by supplying the proper ...
https://dev.mysql.com/doc/refman/8.4/en/fetching-spatial-data.html
Fetching spatial data in internal format: Fetching geometry values using internal format can be useful in table-to-table transfers: CREATE TABLE geom2 (g GEOMETRY) SELECT g FROM geom; Fetching spatial data in WKT format: The ST_AsText() function ...
https://dev.mysql.com/doc/refman/8.4/en/fractional-seconds.html
Previously, the temporal type keyword was ignored and these constructs produced the string value. MySQL has fractional seconds support for TIME, DATETIME, and TIMESTAMP values, with up to microseconds (6 digits) precision: To define a column that ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-system-tables.html
The following table aliases are used to shorten the query string: INFORMATION_SCHEMA.INNODB_TABLES: a INFORMATION_SCHEMA.INNODB_TABLESPACES: b INFORMATION_SCHEMA.INNODB_TABLESTATS: c An IF() control flow function is used to account for compressed ...
https://dev.mysql.com/doc/refman/8.4/en/install-component.html
Example: INSTALL COMPONENT 'file://component1', 'file://component2' SET GLOBAL component1.var1 = 12 + 3, PERSIST component2.var2 = 'strings'; Omitting PERSIST or GLOBAL is equivalent to specifying GLOBAL. Subqueries, stored functions, and aggregate ...[SET variable = expr [, variable = expr] ...] variable: { {GLOBAL | @@GLOBAL.} [component_prefix.]system_var_name | {PERSIST | @@PERSIST.} [component_prefix.]system_var_name } This statement installs one or more components, which become active ...
https://dev.mysql.com/doc/refman/8.4/en/ipv6-support.html
For example: mysql> CREATE USER 'bill'@'::1' IDENTIFIED BY 'secret'; mysql> GRANT SELECT ON mydb.* TO 'bill'@'::1'; IPv6 functions enable conversion between string and internal format IPv6 address formats, and checking whether values represent valid ... Support for IPv6 in MySQL includes these capabilities: MySQL Server can accept TCP/IP connections from clients connecting over ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-digests.html
Warning Setting the max_digest_length system variable to zero disables digest production, which also disables server functionality that requires digests. The MySQL server is capable of maintaining statement digest information. The digesting process ...