MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 51 to 60 of 77 total results

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

| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ... | [CONSTRAINT [symbol]] UNIQUE [INDEX | KEY] [index_name] [index_type] (key_part,...) [index_option] ... (Some valid select or union statement) CREATE TABLE creates ...

14.9.4 Full-Text Stopwords

https://dev.mysql.com/doc/refman/9.7/en/fulltext-stopwords.html

The stopword list is loaded and searched for full-text queries using the server character set and collation (the values of the character_set_server and collation_server system variables). False hits or misses might occur for stopword lookups if the ...

15.1.22 CREATE PROCEDURE and CREATE FUNCTION Statements

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

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, ...

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 ...

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.10.1 Unicode Character Sets

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 ...

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.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 ...

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} ...

Displaying 51 to 60 of 77 total results