Search Results
https://dev.mysql.com/doc/refman/8.4/en/show-index.html
These two statements are equivalent: SHOW INDEX FROM mytable FROM mydb; SHOW INDEX FROM mydb.mytable; The optional EXTENDED keyword causes the output to include information about hidden indexes that MySQL uses internally and are not accessible by ...
https://dev.mysql.com/doc/refman/8.4/en/switchable-optimizations.html
The parent query does not set a user variable, since rewriting it may affect the order of execution, which could lead to unexpected results if the variable is accessed more than once in the same query. Its value is a set of flags, each of which has ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.full.html
After you have created a full backup, you might perform incremental backups (which are smaller and faster) for the next several backup tasks. This section outlines some of the things to consider when deciding on a strategy for creating full backups.
https://dev.mysql.com/doc/mysql-errors/8.4/en/client-error-reference.html
Error number: 2072; Symbol: CR_INVALID_FACTOR_NO; Message: Invalid first argument for MYSQL_OPT_USER_PASSWORD option. Client error messages originate from within the MySQL client library. Here is an example client error message, as displayed by the ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-audit-plugins.html
The first time the server calls event_notify for a thread, it creates a binding of the plugin to the thread. */ MYSQL_AUDIT_CONNECTION_DISCONNECT = 1 << 1, /** occurs after COM_CHANGE_USER RPC is completed. */ MYSQL_AUDIT_CONNECTION_PRE_AUTHENTICATE ... This section describes how to write a server-side audit plugin, using the example plugin found in the plugin/audit_null directory of MySQL source ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-privileges.html
mysql> GRANT SELECT, INSERT, CREATE, DROP, ALTER, UPDATE ON output_schema.* TO 'user_name'@'%'; For more information, see Privileges Provided by MySQL and Default MySQL Privileges.
https://dev.mysql.com/doc/internals/en/frm-file-format.html
Regardless of the storage engine you choose, every MySQL table you create is represented on disk by a .frm file that describes the table's format (that is, the table definition). The .frm format is the same on all platforms, but in the description ...The file bears the same name as the table, with an .frm ...
https://dev.mysql.com/doc/ndbapi/en/ndb-error-codes-schema-error.html
The following list enumerates all NDB errors of type SE (Schema error).
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbtransaction.html
NdbTransaction::getNdbIndexOperation() Description This method is used to create an NdbIndexOperation associated with a given table. NdbTransaction::getNdbIndexScanOperation() Description This method is used to create an NdbIndexScanOperation ...A ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-prepare-a-forecasting-model.html
To ensure reliable predictions, you should create an additional validation dataset. You can reserve 20% of the records in the training dataset to create the validation dataset. mysql> CREATE DATABASE forecasting_data; mysql> USE forecasting_data; ...