Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysqladmin.html
drop db_name Delete the database named db_name and all its tables. Caution Do not use this command used if the server was started with the --skip-grant-tables option. This is true even if you precede the password command with flush-privileges on the ...You can use it to check the server's configuration and current status, to create and drop databases, and ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-pre-filtering.html
Pre-filtering can be applied to either the producer or consumer stage of event processing: To configure pre-filtering at the producer stage, several tables can be used: setup_instruments indicates which instruments are available. An instrument ...
https://dev.mysql.com/doc/refman/8.4/en/temporary-files.html
The maximum disk space required is determined by the following expression: (length of what is sorted + sizeof(row pointer)) * number of matched rows * 2 The row pointer size is usually four bytes, but may grow in the future for really big tables.
https://dev.mysql.com/doc/refman/8.4/en/upgrade-binary-package.html
For example: mysqld_safe --user=mysql --datadir=/path/to/existing-datadir & If there are encrypted InnoDB tablespaces, use the --early-plugin-load option to load the keyring plugin. When you start the MySQL 8.4 server, it automatically detects ...
https://dev.mysql.com/doc/refman/8.4/en/view-restrictions.html
The maximum number of tables that can be referenced in the definition of a view is 61. However, a view that is processed with the temptable algorithm is unable to take advantage of indexes on its underlying tables (although indexes can be used ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-mysqlai-ml-score.html
ML_SCORE Syntax mysql> CALL sys.ML_SCORE(table_name, target_column_name, model_handle, metric, score, [options]); options: { JSON_OBJECT("key","value"[,"key","value"] ...) "key","value": { ['threshold', 'N'] ['topk', 'N'] ['remove_seen', ...
https://dev.mysql.com/doc/refman/8.4/en/manual-info.html
Typographical and Syntax Conventions This manual uses certain typographical conventions: Text in this style is used for SQL statements; database, table, and column names; program listings and source code; and environment variables. Example: “To ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-installation.html
$> mysql -u root -p -D mysql < audit_log_filter_linux_install.sql Enter password: (enter root password here) It is possible to specify a custom database for storing JSON filter tables when you run the installation script. $> mysql -u root -p -D ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-generate-content.html
For Running Batch Queries, add the natural-language queries to a column in a new or existing table. However, there are also concerns about job displacement and bias in AI decision-making.\n\nAs AI continues to evolve, it is essential to address ...
https://dev.mysql.com/doc/refman/8.4/en/json.html
A maximum of 3 JSON columns per NDB table is supported. A direct assignment of the column value (for example, UPDATE mytable SET jcol = '{"a": 10, "b": 25}') cannot be performed as a partial update. The input column and the target column must be the ...The JSON data type provides these advantages over storing JSON-format strings in a string column: Automatic validation of JSON documents stored in JSON ...