PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/charset-configuration.html
However, when character_set_system differs from character_set_server or character_set_client, and you input characters manually (as database object identifiers, column values, or both), these may be displayed incorrectly in output from the client or ... The MySQL server has a compiled-in default character set and ...
https://dev.mysql.com/doc/refman/5.7/en/charset-mysql.html
The INFORMATION_SCHEMA COLLATIONS table and the SHOW COLLATION statement have a column that indicates for each collation whether it is the default for its character set (Yes if so, empty if not). To display the available character sets, use the ...
https://dev.mysql.com/doc/refman/5.7/en/charset-national.html
Standard SQL defines NCHAR or NATIONAL CHAR as a way to indicate that a CHAR column should use some predefined character set. For example, these data type declarations are equivalent: CHAR(10) CHARACTER SET utf8 NATIONAL CHARACTER(10) NCHAR(10) As ...
https://dev.mysql.com/doc/refman/5.7/en/charset-repertoire.html
A column having the ascii character set has ASCII repertoire because of its character set. IF(column1 < column2, 'smaller', 'greater') The result repertoire is ASCII because the two string arguments (the second argument and the third argument) both ... The repertoire of a character set is the collection of characters in the ...
https://dev.mysql.com/doc/refman/5.7/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 ...
https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-utf8mb4.html
When converting utf8mb3 columns to utf8mb4, you need not worry about converting supplementary characters because there are none. The utf8mb4 character set has these characteristics: Supports BMP and supplementary characters. utf8mb4 contrasts with ...
https://dev.mysql.com/doc/refman/5.7/en/charset.html
The default MySQL server character set and collation are latin1 and latin1_swedish_ci, but you can specify character sets at the server, database, table, column, and string literal levels. MySQL includes character set support that enables you to ...
https://dev.mysql.com/doc/refman/5.7/en/comparisons-using-subqueries.html
WHERE 'a' = (SELECT column1 FROM t1) MySQL also permits this construct: non_subquery_operand LIKE (subquery) At one time the only legal place for a subquery was on the right side of a comparison, and you might still find some old DBMSs that insist ... The most common use of a subquery is in the form: non_subquery_operand comparison_operator (subquery) Where comparison_operator is one of these operators: = > < >= <= <> != <=> For example: ...
https://dev.mysql.com/doc/refman/5.7/en/create-user.html
Plugin names are stored in the plugin column of the mysql.user system table. CREATE USER [IF NOT EXISTS] user [auth_option] [, user [auth_option]] ... [REQUIRE {NONE | tls_option [[AND] tls_option] ...}] [WITH resource_option [resource_option] ...] ...
https://dev.mysql.com/doc/refman/5.7/en/creating-accounts.html
The reason for this is that the anonymous-user account has a more specific Host column value than the 'finley'@'%' account and thus comes earlier in the user table sort order. To manage MySQL accounts, use the SQL statements intended for that ...