PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/windows-pluggable-authentication.html
To verify plugin installation, examine the Information Schema PLUGINS table or use the SHOW PLUGINS statement (see Section 5.5.2, “Obtaining Server Plugin Information”). You should also execute GRANT statements (not shown) that grant each ...
https://dev.mysql.com/doc/refman/5.7/en/windows-select-server.html
The following table shows the available servers for Windows in MySQL 5.7. The SHOW ENGINES statement displays which engines a given server supports. Binary Description mysqld Optimized binary with named-pipe support mysqld-debug Like mysqld, but ...
https://dev.mysql.com/doc/refman/5.7/en/x-plugin-status-variables.html
If the bind has failed, or if the skip_networking option has been used, the value shows UNDEFINED. If a network bind has failed, or if the skip_networking system variable is enabled, the value shows UNDEFINED. Mysqlx_errors_unknown_message_type The ...
https://dev.mysql.com/doc/refman/5.7/en/xml-functions.html
Table 12.16 XML Functions Name Description ExtractValue() Extract a value from an XML string using XPath notation UpdateXML() Return replaced XML fragment This section discusses XML and related functionality in MySQL. Note It is possible to obtain ...
https://dev.mysql.com/doc/refman/5.7/en/account-locking.html
The output from SHOW CREATE USER indicates whether an account is locked or unlocked. MySQL supports locking and unlocking user accounts using the ACCOUNT LOCK and ACCOUNT UNLOCK clauses for the CREATE USER and ALTER USER statements: When used with ...
https://dev.mysql.com/doc/refman/5.7/en/adding-collation-choosing-id.html
To add a collation, you must choose an ID value that is not currently used. The range of IDs from 1024 to 2047 is reserved for user-defined collations. The collation ID that you choose appears in these contexts: The ID column of the Information ...
https://dev.mysql.com/doc/refman/5.7/en/adding-collation-unicode-uca.html
Table 10.4 MySQL Character Sets Available for User-Defined UCA Collations Character Set Base Collation utf8 utf8_unicode_ci ucs2 ucs2_unicode_ci utf16 utf16_unicode_ci utf32 utf32_unicode_ci The following sections show how to add a collation that is ... This section describes how to add a UCA collation for a Unicode character set by writing the <collation> element within a <charset> character set description in the MySQL Index.xml ...
https://dev.mysql.com/doc/refman/5.7/en/aggregate-functions.html
If an approximate row count is sufficient, use SHOW TABLE STATUS. 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 ...
https://dev.mysql.com/doc/refman/5.7/en/alter-tablespace.html
ALTER TABLESPACE tablespace_name {ADD | DROP} DATAFILE 'file_name' [INITIAL_SIZE [=] size] [WAIT] ENGINE [=] engine_name This statement is used either to add a new data file, or to drop a data file from a tablespace. The ADD DATAFILE variant ...
https://dev.mysql.com/doc/refman/5.7/en/any-in-some-subqueries.html
Thus, these two statements are the same: SELECT s1 FROM t1 WHERE s1 <> ANY (SELECT s1 FROM t2); SELECT s1 FROM t1 WHERE s1 <> SOME (SELECT s1 FROM t2); Use of the word SOME is rare, but this example shows why it might be useful. The expression is ...