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/replication-semisync-interface.html
To enable or disable the plugin, set this variable to 1 or 0, respectively. This is 1 if the plugin has been enabled and the replication I/O thread is running, 0 otherwise. The administrative interface to semisynchronous replication has several ...
https://dev.mysql.com/doc/refman/5.7/en/row-subqueries.html
If this row has col3 and col4 values equal to the col1 and col2 values of any rows in t1, the WHERE expression is TRUE and each query returns those t1 rows. When a subquery returns a single column, this is regarded as a scalar value and not as a ...
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/show-binary-logs.html
This statement is used as part of the procedure described in Section 13.4.1.1, “PURGE BINARY LOGS Statement”, that shows how to determine which logs can be purged. A user with the SUPER or REPLICATION CLIENT privilege may execute this statement.
https://dev.mysql.com/doc/refman/5.7/en/show-binlog-events.html
SHOW BINLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count] Shows the events in the binary log. If you do not specify 'log_name', the first binary log is displayed. The LIMIT clause has the same syntax as for the SELECT statement.
https://dev.mysql.com/doc/refman/5.7/en/show-collation.html
SHOW COLLATION [LIKE 'pattern' | WHERE expr] This statement lists collations supported by the server. Sortlen This is related to the amount of memory required to sort strings expressed in the character set. By default, the output from SHOW ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-table.html
To use this statement, you must have some privilege for the table. SHOW CREATE TABLE tbl_name Shows the CREATE TABLE statement that creates the named table. row *************************** Table: t Create Table: CREATE TABLE `t` ( `id` int(11) NOT ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-view.html
SHOW CREATE VIEW view_name This statement shows the CREATE VIEW statement that creates the named view. row *************************** View: v Create View: CREATE ALGORITHM=UNDEFINED DEFINER=`bob`@`localhost` SQL SECURITY DEFINER VIEW `v` AS select ...
https://dev.mysql.com/doc/refman/5.7/en/show-engines.html
This is particularly useful for checking whether a storage engine is supported, or to see what the default engine is. SHOW [STORAGE] ENGINES SHOW ENGINES displays status information about the server's storage engines. For information about MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/show-plugins.html
This is the name used to refer to the plugin file in statements such as INSTALL PLUGIN and UNINSTALL PLUGIN. This file is located in the directory named by the plugin_dir system variable. row *************************** Name: binlog Status: ACTIVE ...