Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/collection-indexing.html
To make large collections of documents more efficient to navigate you can create an index based on one or more fields found in the documents in the collection. Creating an Index Collection indexes are ordinary MySQL indexes on virtual columns that ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/collection-indexing.html
To make large collections of documents more efficient to navigate you can create an index based on one or more fields found in the documents in the collection. Creating an Index Collection indexes are ordinary MySQL indexes on virtual columns that ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-filter-definitions.html
For information about using JSON data in MySQL, see Section 13.5, “The JSON Data Type”. Filter definitions have this form, where actions indicates how filtering takes place: { "filter": actions } The following discussion describes permitted ...
https://dev.mysql.com/doc/refman/8.4/en/cast-functions.html
Table 14.15 Cast Functions and Operators Name Description Deprecated BINARY Cast a string to a binary string Yes CAST() Cast a value as a certain type CONVERT() Cast a value as a certain type Cast functions and operators enable conversion of values ...
https://dev.mysql.com/doc/refman/8.4/en/converting-tables-to-innodb.html
If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines and tips before converting. Note Partitioned MyISAM tables created in previous versions of MySQL are not compatible ...
https://dev.mysql.com/doc/refman/8.4/en/mathematical-functions.html
ABS(X) Returns the absolute value of X, or NULL if X is NULL. An implication of this is that ABS(-9223372036854775808) produces an error because the result cannot be stored in a signed BIGINT value. mysql> SELECT ABS(2); -> 2 mysql> SELECT ABS(-32); ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-restore.html
The NDB Cluster restoration program is implemented as a separate command-line utility ndb_restore, which can normally be found in the MySQL bin directory. This program reads the files created as a result of the backup and inserts the stored ...
https://dev.mysql.com/doc/refman/8.4/en/mysqld-safe.html
mysqld_safe is the recommended way to start a mysqld server on Unix. mysqld_safe adds some safety features such as restarting the server when an error occurs and logging runtime information to an error log. A description of error logging is given ...
https://dev.mysql.com/doc/refman/8.4/en/secure-client-programming.html
Client applications that access MySQL should use the following guidelines to avoid interpreting external data incorrectly or exposing sensitive information. Handle External Data Properly Handle MySQL Error Messages Properly Handle External Data ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-supported-file-formats.html
Review the various file formats supported for loading structured, semi-structured, and unstructured data in MySQL HeatWave from different sources. Parquet Delta lake tables (as of MySQL 9.5.0) Supported File Formats for Unstructured Data A Vector ...