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/null-values.html
For text file import or export operations performed with LOAD DATA or SELECT ... Use of \N in text files is unaffected by the deprecation of \N in SQL statements. The NULL value means “no data.” NULL can be written in any lettercase. Treatment ...
https://dev.mysql.com/doc/refman/5.7/en/option-files.html
Many option files are plain text files, created using any text editor. In the latter context, if “x” is not a valid escape sequence character, \x becomes “x” rather than \x. Most MySQL programs can read startup options from option files ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations.html
Partitioned tables do not support FULLTEXT indexes or searches, even for partitioned tables employing the InnoDB or MyISAM storage engine. This section discusses current restrictions and limitations on MySQL partitioning support. The following ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-statements-current-table.html
To change this value, set the performance_schema_max_sql_text_length system variable at server startup. DIGEST_TEXT The normalized statement digest text, or NULL if the statements_digest consumer is no. Consequently, values selected from the ...The ...
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. A statement prepared in stored program context cannot refer to stored procedure or function parameters or local variables because they go out ... PREPARE stmt_name FROM preparable_stmt The PREPARE statement prepares a SQL statement and assigns it a name, stmt_name, by which to refer to the statement ...
https://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html
MySQL privileges differ in the contexts in which they apply and at different levels of operation: Administrative privileges enable users to manage operation of the MySQL server. Summary of Available Privileges Privilege Descriptions ... The ...
https://dev.mysql.com/doc/refman/5.7/en/query-cache-operation.html
Comparison with statements in the query cache is based on the text of the statement after expansion of ? parameter markers. That is, for query cache purposes, prepared statements issued using the binary protocol are distinct from prepared statements ... Note The query cache is deprecated as of MySQL 5.7.20, and is removed in MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-functions.html
CREATE FUNCTION GTID_INTERSECTION(gs1 LONGTEXT, gs2 LONGTEXT) RETURNS LONGTEXT RETURN GTID_SUBTRACT(gs1, GTID_SUBTRACT(gs1, gs2)) | This function returns the symmetric difference between two GTID sets, that is, the GTIDs that exist in gs1 but not in ... This section provides examples of stored functions (see Chapter 23, Stored Objects) which you can create using some of the built-in functions provided by MySQL for use with GTID-based replication, listed here: GTID_SUBSET(): Shows whether one GTID set is a subset of ...
https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html
Create a text file containing the password-assignment statement on a single line. Create a text file containing the password-assignment statement on a single line. If you have never assigned a root password for MySQL, the server does not require a ...
https://dev.mysql.com/doc/refman/5.7/en/security-against-attack.html
(See Section 6.1.2.4, “Password Hashing in MySQL”, for a discussion of the different password handling methods.) All other information is transferred as text, and can be read by anyone who is able to watch the connection. The output of ... When ...