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/row-constructor-optimization.html
For example, these two statements are semantically equivalent: SELECT * FROM t1 WHERE (column1,column2) = (1,1); SELECT * FROM t1 WHERE column1 = 1 AND column2 = 1; In addition, the optimizer handles both expressions the same way. row ...The ...
https://dev.mysql.com/doc/refman/5.7/en/selecting-columns.html
If you do not want to see entire rows from your table, just name the columns in which you are interested, separated by commas.
https://dev.mysql.com/doc/refman/5.7/en/selecting-rows.html
Instead, you're usually more interested in answering a particular question, in which case you specify some constraints on the information you want. String comparisons normally are case-insensitive, so you can specify the name as 'bowser', 'BOWSER', ... As shown in the preceding section, it is easy to retrieve an entire ...
https://dev.mysql.com/doc/refman/5.7/en/show-plugins.html
Type The type of plugin, such as STORAGE ENGINE, INFORMATION_SCHEMA, or AUTHENTICATION. For plugins installed with INSTALL PLUGIN, the Name and Library values are also registered in the mysql.plugin system table. For information about plugin data ...
https://dev.mysql.com/doc/refman/5.7/en/source-thread-states.html
The following list shows the most common states you may see in the State column for the Binlog Dump thread of the replication source. Master has sent all binlog to slave; waiting for more updates The thread has read all remaining updates from the ...If you see no Binlog Dump threads on a source, this means that replication is not running; that is, that no replicas are currently ...
https://dev.mysql.com/doc/refman/5.7/en/sql-compound-statements.html
These objects are defined in terms of SQL code that is stored on the server for later invocation (see Chapter 23, Stored Objects). A compound statement is a block that can contain other blocks; declarations for variables, condition handlers, and ...
https://dev.mysql.com/doc/refman/5.7/en/storage-engines-other.html
For further information, documentation, installation guides, bug reporting or for any help or assistance with these engines, please contact the developer of the engine directly. For more information on developing a customer storage engine that can ... Other storage engines may be available from third parties and community members that have used the Custom Storage Engine ...
https://dev.mysql.com/doc/refman/5.7/en/subquery-optimization.html
Note A limitation on UPDATE and DELETE statements that use a subquery to modify a single table is that the optimizer does not use semijoin or materialization subquery optimizations. As a workaround, try rewriting them as multiple-table UPDATE and ...
https://dev.mysql.com/doc/refman/5.7/en/sys-io-global-by-file-by-bytes.html
total The total number of bytes read and written for the file. These views summarize global I/O consumers to display amount of I/O, grouped by file. By default, rows are sorted by descending total I/O (bytes read and written). The ...
https://dev.mysql.com/doc/refman/5.7/en/working-with-null.html
The NULL value can be surprising until you get used to it. Conceptually, NULL means “a missing unknown value” and it is treated somewhat differently from other values. In MySQL, 0 or NULL means false and anything else means true. This special ...