PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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/commit.html
Because of this, SHOW PROCESSLIST displays Rolling back in the State column for the session, not only for explicit rollbacks performed with the ROLLBACK statement but also for implicit rollbacks. SET autocommit disables or enables the default ...
https://dev.mysql.com/doc/refman/5.7/en/comparison-operators.html
For DATE and DATETIME columns that are declared as NOT NULL, you can find the special date '0000-00-00' by using a statement like this: SELECT * FROM tbl_name WHERE date_column IS NULL This is needed to get some ODBC applications to work because ...
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-event.html
This event executes once—one hour following its creation—by running an SQL statement that increments the value of the myschema.mytable table's mycol column by 1. CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON ...
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 ...