MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 61 to 70 of 167 total results

https://dev.mysql.com/doc/refman/8.0/en/cast-functions.html

Table 14.15 Cast Functions and Operators Name Description Deprecated BINARY Cast a string to a binary string 8.0.27 CAST() Cast a value as a certain type CONVERT() Cast a value as a certain type Cast functions and operators enable conversion of ...

12.3 Specifying Character Sets and Collations

https://dev.mysql.com/doc/refman/8.0/en/charset-syntax.html

There are default settings for character sets and collations at four levels: server, database, table, and column. The description in the following sections may appear complex, but it has been found in practice that multiple-level defaulting leads ...

12.9.8 Converting Between 3-Byte and 4-Byte Unicode Character Sets

https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-conversion.html

This section describes issues that you may face when converting character data between the utf8mb3 and utf8mb4 character sets. Note This discussion focuses primarily on converting between utf8mb3 and utf8mb4, but similar principles apply to ...

6.2.2.1 Using Options on the Command Line

https://dev.mysql.com/doc/refman/8.0/en/command-line-options.html

Program options specified on the command line follow these rules: Options are given after the command name. An option argument begins with one dash or two dashes, depending on whether it is a short form or long form of the option name. For example, ...

14.4.2 Comparison Functions and Operators

https://dev.mysql.com/doc/refman/8.0/en/comparison-operators.html

Table 14.4 Comparison Operators Name Description > Greater than operator >= Greater than or equal operator < Less than operator <>, != Not equal operator <= Less than or equal operator <=> NULL-safe equal to operator = Equal operator BETWEEN ...

7.1.12.1 Connection Interfaces

https://dev.mysql.com/doc/refman/8.0/en/connection-interfaces.html

This section describes aspects of how the MySQL server manages client connections. Network Interfaces and Connection Manager Threads Client Connection Thread Management Connection Volume Management Network Interfaces and Connection Manager Threads ...

15.1.15 CREATE INDEX Statement

https://dev.mysql.com/doc/refman/8.0/en/create-index.html

CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ... This guideline is especially important for InnoDB tables, where the primary key determines the ...

15.1.17 CREATE PROCEDURE and CREATE FUNCTION Statements

https://dev.mysql.com/doc/refman/8.0/en/create-procedure.html

By default, a stored routine is associated with the default database. To associate the routine explicitly with a given database, specify the name as db_name.sp_name when you create it. The CREATE FUNCTION statement is also used in MySQL to support ...

7.4.2.3 Error Event Fields

https://dev.mysql.com/doc/refman/8.0/en/error-log-event-fields.html

Error events intended for the error log contain a set of fields, each of which consists of a key/value pair. An event field may be classified as core, optional, or user-defined: A core field is set up automatically for error events. However, its ...

7.4.2.5 Priority-Based Error Log Filtering (log_filter_internal)

https://dev.mysql.com/doc/refman/8.0/en/error-log-priority-based-filtering.html

The log_filter_internal log filter component implements a simple form of log filtering based on error event priority and error code. To affect how log_filter_internal permits or suppresses error, warning, and information events intended for the ...

Displaying 61 to 70 of 167 total results