PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/set-variable.html
They use the = assignment operator, but the := assignment operator is also permitted for this purpose. This statement assigns a value to a user-defined variable and a system variable: SET @x = 1, SESSION sql_mode = ''; If you set multiple system ...
https://dev.mysql.com/doc/refman/5.7/en/show-columns.html
The conditions under which this occurs are described in Section 13.1.18.6, “Silent Column Specification Changes”. This value is displayed only if you use the FULL keyword. This is NULL if the column has an explicit default of NULL, or if the ...
https://dev.mysql.com/doc/refman/5.7/en/slow-query-log.html
To make this easier, you can use the mysqldumpslow command to process a slow query log file and summarize its contents. This behavior can be changed using log_slow_admin_statements and log_queries_not_using_indexes, as described later. By default, ... The slow query log consists of SQL statements that take more than long_query_time seconds to execute and require at least min_examined_row_limit rows to be ...
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/audit-log-installation.html
This section describes how to install or uninstall MySQL Enterprise Audit, which is implemented using the audit log plugin and related elements described in Section 6.4.5.1, “Elements of MySQL Enterprise Audit”. To avoid this overhead, do not ...For general information about installing plugins, see Section 5.5.1, “Installing and Uninstalling ...
https://dev.mysql.com/doc/refman/5.7/en/automatic-start.html
This section discusses methods for starting and stopping the MySQL server. systemd, the mysqld_safe and mysql.server scripts, Solaris SMF, and the macOS Startup Item (or MySQL Preference Pane) can be used to start the server manually, or ...
https://dev.mysql.com/doc/refman/5.7/en/c-api-info.html
The MySQL C API Developer Guide is published in standalone form, not as part of the MySQL Reference Manual.