PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.7Kb
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/data-type-defaults.html
In the definition of an integer column, it is an alias for NOT NULL AUTO_INCREMENT UNIQUE. Implicit Default Handling If a data type specification includes no explicit DEFAULT value, MySQL determines the default value as follows: If the column can ...
https://dev.mysql.com/doc/refman/5.7/en/help.html
HELP 'search_string' The HELP statement returns online information from the MySQL Reference Manual. The HELP statement searches the help tables for the given search string and displays the result of the search. The search string can contain the ...
https://dev.mysql.com/doc/refman/5.7/en/reset-master.html
The value of the gtid_purged system variable is set to an empty string (''), the global value (but not the session value) of the gtid_executed system variable is set to an empty string, and the mysql.gtid_executed table is cleared (see ... RESET ...
https://dev.mysql.com/doc/refman/5.7/en/selecting-rows.html
String comparisons normally are case-insensitive, so you can specify the name as 'bowser', 'BOWSER', and so forth. As shown in the preceding section, it is easy to retrieve an entire table. But typically you don't want to see the entire table, ...
https://dev.mysql.com/doc/refman/5.7/en/encrypted-connection-protocols-ciphers.html
If you set a TLS version parameter to the empty string, encrypted connections cannot be established: tls_version: The server does not permit encrypted incoming connections. MySQL supports multiple TLS protocols and ciphers, and enables configuring ...
https://dev.mysql.com/doc/refman/5.7/en/server-status-variables.html
If the group is operating in multi-primary mode, shows an empty string. The MySQL server maintains many status variables that provide information about its operation. You can view these variables and their values by using the SHOW [GLOBAL | ...
https://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html
As a string indicating an offset from UTC of the form [H]H:MM, prefixed with a + or -, such as '+10:00', '-6:00', or '+05:30'. This section describes the time zone settings maintained by MySQL, how to load the system tables required for named time ...
https://dev.mysql.com/doc/refman/5.7/en/constraint-invalid-data.html
For strings, MySQL stores either the empty string or as much of the string as can be stored in the column. If you try to store a string that does not start with a number into a numeric column, MySQL Server stores 0. If you try to store NULL into a ... MySQL 5.7.5 and later uses strict SQL mode by default, which treats invalid values such that the server rejects them and aborts the statement in which they occur (see Section 5.1.10, “Server SQL ...