Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-size-pl.html
This is a Perl script that can be used to estimate the amount of space that would be required by a MySQL database if it were converted to use the NDBCLUSTER storage engine. Unlike the other utilities discussed in this section, it does not require ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-utilities-table-export.html
MySQL Shell's table export utility util.exportTable() exports a MySQL relational table into a data file, either on the local server or in an Oracle Cloud Infrastructure Object Storage bucket. The data can then be uploaded into a table on a target ...
https://dev.mysql.com/doc/refman/8.4/en/cast-functions.html
For a value that cannot be successfully converted to YEAR, return NULL. Regardless of the syntax used, the function returns NULL if expr is NULL. If the expression to cast is NULL, the function result is NULL. row *************************** Table: ... 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 from one data type to ...
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 Supported File Formats for Unstructured Data A Vector store can ingest files from the ...
https://dev.mysql.com/doc/refman/8.4/en/enum.html
Creating and Using ENUM Columns Index Values for Enumeration Literals Handling of Enumeration Literals Empty or NULL Enumeration Values Enumeration Sorting Enumeration Limitations Creating and Using ENUM Columns An enumeration value must be a quoted ... An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation ...
https://dev.mysql.com/doc/refman/8.4/en/json-modification-functions.html
All members of the second object which do not have a corresponding key in the first object, and whose value is not the JSON null literal. All members with a key that exists in both the first and the second object, and whose value in the second ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-files-table.html
The value is NULL for all data files except for predefined system tablespace data files. A NULL value for a predefined system tablespace data file indicates that a file size limit was not defined explicitly. For NDB: For undo log files, this column ... The FILES table provides information about the files in which MySQL tablespace data is ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-tips.html
Connection id: 1 Current database: test Query OK, 1 row affected (1.30 sec) mysql> SELECT * FROM t; +------+ | a | +------+ | NULL | +------+ 1 row in set (0.05 sec) The @a user variable has been lost with the connection, and after the reconnection ... This section provides information about techniques for more effective use of mysql and about mysql operational ...
https://dev.mysql.com/doc/refman/8.4/en/signal.html
It is illegal to assign NULL to a condition information item in a SIGNAL statement. SIGNAL provides error information to a handler, to an outer portion of the application, or to the client. Also, it provides control over the error's characteristics ...
https://dev.mysql.com/doc/internals/en/full-text-search.html
MySQL uses Ranking with Vector Spaces for ordinary full-text queries. Rank, also known as relevance rank, also known as relevance measure, is a number that tells us how good a match is. Vector Space, which MySQL sometimes calls "natural language", ...