Search Results
https://dev.mysql.com/doc/refman/8.4/en/charset-metadata.html
Thus column names, database names, user names, version names, and most of the string results from SHOW are metadata. The metadata requirements mean that the return values of the USER(), CURRENT_USER(), SESSION_USER(), SYSTEM_USER(), DATABASE(), and ... Metadata is “the data about the data.” Anything that describes the database—as opposed to being the contents of the database—is ...
https://dev.mysql.com/doc/refman/8.4/en/explain.html
In this case, the statement displays output only for the columns with names matching the string. There is no need to enclose the string within quotation marks unless it contains spaces or other special characters. You should be aware that while this ...In practice, the DESCRIBE keyword is more often used to obtain information about table structure, whereas EXPLAIN is used to obtain a query execution plan (that is, an explanation of how MySQL would execute a ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-statistics-table.html
However, prefix lengths for index specifications in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements are interpreted as number of characters for nonbinary string types (CHAR, VARCHAR, TEXT) and number of bytes for binary string types (BINARY, ...The information_schema_stats_expiry system variable defines the period of time before cached table statistics ...
https://dev.mysql.com/doc/refman/8.4/en/show-index.html
However, prefix lengths for index specifications in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements are interpreted as number of characters for nonbinary string types (CHAR, VARCHAR, TEXT) and number of bytes for binary string types (BINARY, ... SHOW [EXTENDED] {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr] SHOW INDEX returns table index ...
https://dev.mysql.com/doc/relnotes/mysql-cluster/8.4/en/dynxml-auto-changelog-difflist-mysqld-8.4.1-ndb-8.4.1.html
Functionality Added or Changed Bugs Fixed Functionality Added or Changed Important Change: Now, when the removal of a data node file or directory fails with a file does not exist (ENOENT) error, this is treated as a successful removal. (Bug ...It ...
https://dev.mysql.com/doc/relnotes/mysql-cluster/8.4/en/news-8-4-1.html
Functionality Added or Changed Bugs Fixed Functionality Added or Changed Important Change: Now, when the removal of a data node file or directory fails with a file does not exist (ENOENT) error, this is treated as a successful removal. (Bug ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-12.html
Functionality Added or Changed Bugs Fixed Functionality Added or Changed X DevAPI: The following changes have been made to the API: Removed ModifyStatement.arrayDelete() and ModifyStatement.merge(). (WL #11876) Bugs Fixed X DevAPI: When creating an ... Version 8.0.12 is the latest General Availability release of the 8.0 series of MySQL ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-17.html
Deprecation and Removal Notes Functionality Added or Changed Bugs Fixed Deprecation and Removal Notes X DevAPI: The following methods have been deprecated: Collection.find().where() Collection.modify().where() Collection.remove().where() (WL #13009) ... Version 8.0.17 is the latest General Availability release of the 8.0 series of MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlbinlog.html
--base64-output=value Command-Line Format --base64-output=value Type String Default Value AUTO Valid Values AUTONEVERDECODE-ROWS This option determines when events should be displayed encoded as base-64 strings using BINLOG statements. The server's ...
https://dev.mysql.com/doc/workbench/en/wb-develop-sql-editor-results.html
Note MySQL Workbench handles quoting and escaping for strings entered into the result grid, so adding quotes and proper escaping here is optional. Note It is possible to enter a function, or other expression, into a field. Note The "Refresh" button ... The results area of the screen shows the results from executed ...