PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/rewriter-query-rewrite-plugin-installation.html
To install or uninstall the Rewriter query rewrite plugin, choose the appropriate script located in the share directory of your MySQL installation: install_rewriter.sql: Choose this script to install the Rewriter plugin and its associated elements.
https://dev.mysql.com/doc/refman/8.0/en/se-csv-repair.html
mysql> REPAIR TABLE csvtest; +--------------+--------+----------+----------+ | Table | Op | Msg_type | Msg_text | +--------------+--------+----------+----------+ | test.csvtest | repair | status | OK | +--------------+--------+----------+----------+ ... The CSV storage engine supports the CHECK TABLE and REPAIR TABLE statements to verify and, if possible, repair a damaged CSV ...
https://dev.mysql.com/doc/refman/8.0/en/serialized-dictionary-information.html
In addition to storing metadata about database objects in the data dictionary, MySQL stores it in serialized form. SDI data is not updated when the MySQL server is upgraded to a new release or version. The MySQL server uses an internal API that is ...Other storage engines store SDI data in .sdi files that are created for a given table in the table's database ...
https://dev.mysql.com/doc/refman/8.0/en/show-create-procedure.html
SHOW CREATE PROCEDURE proc_name This statement is a MySQL extension. row *************************** Procedure: citycount sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, ...It returns the ...
https://dev.mysql.com/doc/refman/8.0/en/show-master-status.html
row *************************** File: source-bin.000002 Position: 1307 Binlog_Do_DB: test Binlog_Ignore_DB: manual, mysql Executed_Gtid_Set: 3E11FA47-71CA-11E1-9E33-C80AA9429562:1-5 1 row in set (0.00 sec) When global transaction IDs are in use, ...
https://dev.mysql.com/doc/refman/8.0/en/show-plugins.html
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 structures that form the basis of the information displayed by SHOW PLUGINS, see The MySQL ...row *************************** Name: binlog Status: ACTIVE Type: STORAGE ENGINE Library: NULL License: GPL ...
https://dev.mysql.com/doc/refman/8.0/en/show-procedure-status.html
SHOW PROCEDURE STATUS [LIKE 'pattern' | WHERE expr] This statement is a MySQL extension. row *************************** Db: test Name: sp1 Type: PROCEDURE Definer: testuser@localhost Modified: 2018-08-08 13:54:11 Created: 2018-08-08 13:54:11 ...It ...
https://dev.mysql.com/doc/refman/8.0/en/show-replicas.html
From MySQL 8.0.22, use SHOW REPLICAS in place of SHOW SLAVE HOSTS, which is deprecated from that release. {SHOW REPLICAS} Displays a list of replicas currently registered with the source. SHOW REPLICAS should be executed on a server that acts as a ...
https://dev.mysql.com/doc/refman/8.0/en/sorting-rows.html
You may have noticed in the preceding examples that the result rows are displayed in no particular order. It is often easier to examine query output when the rows are sorted in some meaningful way. This means that the order is undefined for columns ...
https://dev.mysql.com/doc/refman/8.0/en/subqueries.html
All subquery forms and operations that the SQL standard requires are supported, as well as a few features that are MySQL-specific. Beginning with MySQL 8.0.19, TABLE and VALUES statements can be used in subqueries. Here is an example of a subquery: ...