Search Results
https://dev.mysql.com/doc/refman/8.4/en/proxy-users.html
Suppose that my_auth_plugin returns a user name of employee to the server, based on the content of 'my_auth_string' and perhaps by consulting some external authentication system. When proxying occurs, the USER() and CURRENT_USER() functions can be ...The plugin that authenticates a given connection may request that the connecting (external) user be treated as a different user for privilege-checking ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-scanning-basic.html
This example illustrates how to use the NDB scanning API. It shows how to perform a scan, how to scan for an update, and how to scan for a delete, making use of the NdbScanFilter and NdbScanOperation classes. The source code for this example may ...
https://dev.mysql.com/doc/x-devapi-userguide/en/connecting-to-a-single-mysqld-node-setup.html
string usr = prompt("Username:"); string pwd = prompt("Password:"); // Connect to MySQL Server on a network machine Session mySession(SessionOption::HOST, "localhost", SessionOption::PORT, 33060, SessionOption::USER, usr, SessionOption::PWD, pwd); ... In this example a connection to a local MySQL Server instance running X Plugin on the default TCP/IP port 33060 is established using the MySQL user account user with its ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-limitations-csv.html
To convert VECTOR to JSON, first convert VECTOR to a STRING data type by using the VECTOR_TO_STRING() function. For example, if col_1 in table_1 is a VECTOR column that you want to convert to JSON, you can do the following: SELECT ... MySQL HeatWave ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-31.html
(WL #15243) Functionality Added or Changed MySQL HeatWave uses dictionary encoding to compress string columns (CHAR, VARCHAR, TEXT). MySQL HeatWave AutoML Functionality Added or Changed MySQL HeatWave AutoML MySQL HeatWave AutoML queries are now ...
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 ...