Search Results
https://dev.mysql.com/doc/refman/8.4/en/information-functions.html
ICU_VERSION() The version of the International Components for Unicode (ICU) library used to support regular expression operations (see Section 14.8.2, “Regular Expressions”). It may be used to time how quickly MySQL processes the expression. The ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-columns-table.html
A UNIQUE index may display as MUL if several columns form a composite UNIQUE index; although the combination of the columns is unique, each column can still hold multiple occurrences of a given value. The related ST_GEOMETRY_COLUMNS table provides ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-repair-options.html
--correct-checksum Command-Line Format --correct-checksum Correct the checksum information for the table. --data-file-length=len, -D len Command-Line Format --data-file-length=len Type Numeric The maximum length of the data file (when re-creating ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-mgm.html
The ndb_mgm management client process is actually not needed to run the cluster. Its value lies in providing a set of commands for checking the cluster's status, starting backups, and performing other administrative functions. The management client ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlbinlog-row-events.html
The combination of --base64-output=DECODE-ROWS and --verbose provides a convenient way to see row events only as SQL statements: $> mysqlbinlog -v --base64-output=DECODE-ROWS log_file ... The following examples illustrate how mysqlbinlog displays ...
https://dev.mysql.com/doc/refman/8.4/en/signal.html
Some signal values cause statement termination; see Effect of Signals on Handlers, Cursors, and Statements. SIGNAL provides error information to a handler, to an outer portion of the application, or to the client. Also, it provides control over the ...
https://dev.mysql.com/doc/refman/8.4/en/silent-column-changes.html
In some cases, MySQL silently changes column specifications from those given in a CREATE TABLE or ALTER TABLE statement. These might be changes to a data type, to attributes associated with a data type, or to an index specification. All changes are ...
https://dev.mysql.com/doc/refman/8.4/en/stored-programs-defining.html
Each stored program contains a body that consists of an SQL statement. This statement may be a compound statement made up of several statements separated by semicolon (;) characters. For example, the following stored procedure has a body made up of ...
https://dev.mysql.com/doc/refman/8.4/en/type-conversion.html
When an operator is used with operands of different types, type conversion occurs to make the operands compatible. For example, MySQL automatically converts strings to numbers as necessary, and vice versa. mysql> SELECT 1+'1'; -> 2 mysql> SELECT ...
https://dev.mysql.com/doc/refman/8.4/en/user-variables.html
You can store a value in a user-defined variable in one statement and refer to it later in another statement. This enables you to pass values from one statement to another. User variables are written as @var_name, where the variable name var_name ...