Search Results
https://dev.mysql.com/doc/refman/8.4/en/string-functions.html
For functions that operate on string positions, the first position is numbered 1. For functions that take length arguments, noninteger arguments are rounded to the nearest integer. ASCII(str) Returns the numeric value of the leftmost character of ...
https://dev.mysql.com/doc/refman/8.4/en/glossary.html
These terms are commonly used in information about the MySQL database server. Files with this extension are always included in backups produced by the mysqlbackup command of the MySQL Enterprise Backup product. Files with this extension are always ...
https://dev.mysql.com/doc/x-devapi-userguide/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-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 ...