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/subquery-materialization.html
(oe_1, oe_2, ..., oe_N) [NOT] IN (SELECT ie_1, i_2, ..., ie_N ...) The predicate has this form, when there is a single outer expression oe and inner expression ie. This query is subject to materialization: SELECT * FROM t1 WHERE t1.a IN (SELECT t2.b ... The optimizer uses materialization to enable more efficient subquery ...
https://dev.mysql.com/doc/refman/5.7/en/table-size-limit.html
For example, you are using MyISAM tables on an operating system that supports files only up to 2GB in size and you have hit this limit for the data file or index file. MyISAM permits data and index files to grow up to 256TB by default, but this ...
https://dev.mysql.com/doc/refman/5.7/en/using-date.html
You should use this format in UPDATE expressions and in the WHERE clause of SELECT statements. However, this conversion is subject to the following exceptions: When you compare two columns When you compare a DATE, TIME, DATETIME, or TIMESTAMP column ...For example: SELECT * FROM t1 WHERE date >= '2003-05-05'; As a convenience, MySQL automatically converts a date to a number if the date is used in numeric context and vice ...
https://dev.mysql.com/doc/refman/5.7/en/windows-restrictions.html
This is because the physical address limit on Windows 32-bit is 4GB and the default setting within Windows is to split the virtual address space between kernel (2GB) and user/applications (2GB). This facility is often used to move the data and index ... The following restrictions apply to use of MySQL on the Windows platform: Process memory On Windows 32-bit platforms, it is not possible by default to use more than 2GB of RAM within a single process, including ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table.html
This is a MySQL extension to standard SQL, which permits only one of each clause per ALTER TABLE statement. For example, to drop multiple columns in a single statement, do this: ALTER TABLE t2 DROP COLUMN c, DROP COLUMN d; If a storage engine does ... ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ADD [COLUMN] (col_name column_definition,...) | ADD {INDEX | KEY} [index_name] [index_type] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/5.7/en/alter-user.html
For information about the conditions under which this occurs for the server logs and how to control it, see Section 6.1.2.3, “Passwords and Logging”. In one case only, the account may be specified with the USER() function: ALTER USER USER() ...
https://dev.mysql.com/doc/refman/5.7/en/apis-php-info.html
The MySQL PHP API manual is now published in standalone form, not as part of the MySQL Reference Manual.
https://dev.mysql.com/doc/refman/5.7/en/binary-log.html
You should not manually edit this file while mysqld is running; doing so would confuse mysqld. However, the benefits of the binary log in enabling you to set up replication and for restore operations generally outweigh this minor performance ... The ...
https://dev.mysql.com/doc/refman/5.7/en/bit-functions.html
An extension for MySQL 8.0 changes this cast-to-BIGINT behavior: Bit functions and operators permit binary string type arguments (BINARY, VARBINARY, and the BLOB types), enabling them to take arguments and produce return values larger than 64 bits.
https://dev.mysql.com/doc/refman/5.7/en/connection-options.html
This section describes options supported by most MySQL client programs that control how client programs establish connections to the server and whether connections are encrypted. Command Options for Connection Establishment Command Options for ...