MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 11 to 20 of 118 total results

https://dev.mysql.com/doc/refman/9.7/en/charset-unicode-sets.html

This section describes the collations available for Unicode character sets and their differentiating properties. MySQL supports multiple Unicode character sets: utf8mb4: A UTF-8 encoding of the Unicode character set using one to four bytes per ...

8.4.9.2 The MySQL Enterprise Firewall Component

https://dev.mysql.com/doc/refman/9.7/en/firewall-component.html

Purpose: Provide an application-level firewall enabling the database administrator to allow or block SQL statements based on matching them against accepted statement patterns. The component-based version of MySQL Enterprise Firewall includes the ...

6.5.1.1 mysql Client Options

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

mysql supports the following options, which can be specified on the command line or in the [mysql] and [client] groups of an option file. For information about option files used by MySQL programs, see Section 6.2.2.2, “Using Option Files”.

14.19.1 Aggregate Function Descriptions

https://dev.mysql.com/doc/refman/9.7/en/aggregate-functions.html

This section describes aggregate functions that operate on sets of values. They are often used with a GROUP BY clause to group values into subsets. If you use an aggregate function in a statement containing no GROUP BY clause, it is equivalent to ...

15.1.11 ALTER TABLE Statement

https://dev.mysql.com/doc/refman/9.7/en/alter-table.html

ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ADD [COLUMN] (col_name column_definition,...) | ADD {INDEX | KEY} ...

12.8.6 Examples of the Effect of Collation

https://dev.mysql.com/doc/refman/9.7/en/charset-collation-effect.html

latin1_swedish_ci latin1_german1_ci latin1_german2_ci Muffler Muffler Müller MX Systems Müller Muffler Müller MX Systems MX Systems MySQL MySQL MySQL The character that causes the different sort orders in this example is ü (German ...

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

https://dev.mysql.com/doc/refman/9.7/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 ...

12.9.5 The utf16 Character Set (UTF-16 Unicode Encoding)

https://dev.mysql.com/doc/refman/9.7/en/charset-unicode-utf16.html

The utf16 character set is the ucs2 character set with an extension that enables encoding of supplementary characters: For a BMP character, utf16 and ucs2 have identical storage characteristics: same code values, same encoding, same length. For a ...

12.9.3 The utf8 Character Set (Deprecated alias)

https://dev.mysql.com/doc/refman/9.7/en/charset-unicode-utf8.html

utf8 is a deprecated alias whose interpretation in SQL statements is controlled by the `INTERPRET_UTF8_AS_UTF8MB4` SQL mode. When the server stores or reports a resolved character set or collation, it uses the canonical `utf8mb3` or `utf8mb4` name ...

6.2.2.1 Using Options on the Command Line

https://dev.mysql.com/doc/refman/9.7/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, ...

Displaying 11 to 20 of 118 total results