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/problems-with-null.html
The concept of the NULL value is a common source of confusion for newcomers to SQL, who often think that NULL is the same thing as an empty string ''. For example, the following statements are completely different: mysql> INSERT INTO my_table ...In ...
https://dev.mysql.com/doc/refman/5.7/en/data-type-defaults.html
With one exception, the default value specified in a DEFAULT clause must be a literal constant; it cannot be a function or an expression. This means, for example, that you cannot set the default for a date column to be the value of a function such ... Data type specifications can have explicit or implicit default ...
https://dev.mysql.com/doc/refman/5.7/en/downgrading-to-previous-series.html
System Table Changes InnoDB Changes Logging Changes SQL Changes System Table Changes In MySQL 5.7.13, system table columns that store user@host string values were increased in length. All credentials are stored in the authentication_string column, ... Before downgrading from MySQL 5.7, review the information in this ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-api-definition.html
It is also subject to future removal.) ConnectionMap Version (or later) NDB 7.5.0 Type or units string Default [...] Range ... HeartbeatThreadPriority Version (or later) NDB 7.5.0 Type or units string Default [...] Range ... (NDB 7.5.0) In an NDB ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-blob.html
See Section 8.4.2.2, “Optimizing for Character and String Types” for reasons why a binary VARCHAR column is sometimes preferable to an equivalent BLOB column. Rather than testing for equality against a very long text string, you can store a hash ... When storing a large blob containing textual data, consider compressing it ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-lifecycle.html
If the GTID has already been used, no error is raised, and the auto-skip function is used to ignore the transaction. A GTID is also assigned to the creation, alteration, or deletion of a database, and of a non-table database object such as a ... The ...
https://dev.mysql.com/doc/refman/5.7/en/load-xml.html
The tagname in the optional ROWS IDENTIFIED BY clause must also be given as a literal string, and must be surrounded by angle brackets (< and >). Important Revoking the FILE privilege (or not granting it in the first place) keeps the user only from ...LOAD XML acts as the complement of running the mysql client in XML output mode (that is, starting the client with the --xml ...
https://dev.mysql.com/doc/refman/5.7/en/prepare.html
preparable_stmt is either a string literal or a user variable that contains the text of the SQL statement. The ? characters should not be enclosed within quotation marks, even if you intend to bind them to string values. A statement prepared in ...
https://dev.mysql.com/doc/refman/5.7/en/programs-overview.html
In addition to the provided SQL functionality, similar to mysql, MySQL Shell provides scripting capabilities for JavaScript and Python and includes APIs for working with MySQL. replace A utility program that performs string replacement in the input ...Later sections provide a more detailed description of each one, with the exception of NDB Cluster ...
https://dev.mysql.com/doc/refman/5.7/en/rename-table.html
RENAME TABLE tbl_name TO new_tbl_name changes internally generated foreign key constraint names and user-defined foreign key constraint names that begin with the string “tbl_name_ibfk_” to reflect the new table name. InnoDB interprets foreign ...