PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/case.html
The CASE statement cannot have an ELSE NULL clause, and it is terminated with END CASE instead of END. This syntax cannot be used to test for equality with NULL because NULL = NULL is false. CASE case_value WHEN when_value THEN statement_list [WHEN ...
https://dev.mysql.com/doc/refman/5.7/en/merge-storage-engine.html
The column of the underlying table and the MERGE table can be NULL. The MERGE storage engine, also known as the MRG_MyISAM engine, is a collection of identical MyISAM tables that can be used as one. “Identical” means that all tables have ...
https://dev.mysql.com/doc/refman/5.7/en/pam-pluggable-authentication.html
Proxy user support: PAM authentication can return to MySQL a user name different from the external user name passed by the client program, based on the PAM groups the external user is a member of and the authentication string provided. The PAM ...
https://dev.mysql.com/doc/refman/5.7/en/update.html
If you update a column that has been declared NOT NULL by setting to NULL, an error occurs if strict SQL mode is enabled; otherwise, the column is set to the implicit default value for the column data type and the warning count is incremented. The ... UPDATE is a DML statement that modifies rows in a ...
https://dev.mysql.com/doc/refman/5.7/en/memory-storage-engine.html
(This is an uncommon feature for implementations of hash indexes.) Columns that are indexed can contain NULL values. To replicate this effect to replicas, the first time that the source uses a given MEMORY table after startup, it logs an event that ... The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in ...
https://dev.mysql.com/doc/refman/5.7/en/charset-introducer.html
A character string literal, hexadecimal literal, or bit-value literal may have an optional character set introducer and COLLATE clause, to designate it as a string that uses a particular character set and collation: [_charset_name] literal [COLLATE ...Escapes are always interpreted by the parser according to the character set given by ...
https://dev.mysql.com/doc/refman/5.7/en/precision-math-expressions.html
If a numeric expression contains any strings, they are converted to double-precision floating-point values and the expression is approximate. For inserts of strings into numeric columns, conversion from string to number is handled as follows if the ... With precision math, exact-value numbers are used as given whenever ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-troubleshoot.html
Attempting to insert a NULL value into a NOT NULL column causes the INSERT to fail, which may only become evident after you reinitialize the daemon_memcached plugin to apply changes to the innodb_memcache.containers table. If cas_column and ... This ...
https://dev.mysql.com/doc/refman/5.7/en/rewriter-query-rewrite-plugin-usage.html
row *************************** id: 1 pattern: SELECT ? pattern_database: NULL replacement: SELECT ? + 1 enabled: YES message: NULL pattern_digest: NULL normalized_pattern: NULL The rule specifies a pattern template indicating which SELECT ... To ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-sql-statements.html
row *************************** PLUGIN_NAME: ndbcluster PLUGIN_VERSION: 1.0 PLUGIN_STATUS: ACTIVE PLUGIN_TYPE: STORAGE ENGINE PLUGIN_TYPE_VERSION: 50729.0 PLUGIN_LIBRARY: NULL PLUGIN_LIBRARY_VERSION: NULL PLUGIN_AUTHOR: MySQL AB PLUGIN_DESCRIPTION: ... This section discusses several SQL statements that can prove useful in managing and monitoring a MySQL server that is connected to an NDB Cluster, and in some cases provide information about the cluster ...