PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/show-triggers.html
SHOW TRIGGERS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TRIGGERS lists the triggers currently defined for tables in a database (the default database unless a FROM clause is given). This statement returns results only for databases ...
https://dev.mysql.com/doc/refman/5.7/en/subquery-optimization-with-exists.html
row *************************** id: 2 select_type: DEPENDENT SUBQUERY table: t2 type: ref_or_null possible_keys: maybe_null_key key: maybe_null_key key_len: 5 ref: func rows: 2 Extra: Using where; Using index ... Triggered equalities can be used by ... Certain optimizations are applicable to comparisons that use the IN (or =ANY) operator to test subquery ...
https://dev.mysql.com/doc/refman/5.7/en/subquery-restrictions.html
In general, you cannot modify a table and select from the same table in a subquery. FROM t ...); Exception: The preceding prohibition does not apply if for the modified table you are using a derived table and that derived table is materialized ...
https://dev.mysql.com/doc/refman/5.7/en/sys-metrics.html
The metric type determines the source from which the name is taken: For global status variables: The VARIABLE_NAME column of the global_status table For InnoDB metrics: The NAME column of the INNODB_METRICS table For other metrics: A view-provided ... This view summarizes MySQL server metrics to show variable names, values, types, and whether they are ...
https://dev.mysql.com/doc/refman/5.7/en/sys-sys-get-config.html
Given a configuration option name, returns the option value from the sys_config table, or the provided default value (which may be NULL) if the option does not exist in the table. If so, the routine uses the variable value without reading the ...If ...
https://dev.mysql.com/doc/refman/5.7/en/triggers.html
A trigger is a named database object that is associated with a table, and that activates when a particular event occurs for the table. Some uses for triggers are to perform checks of values to be inserted into a table or to perform calculations on ...For example, rows can be inserted by INSERT or LOAD DATA statements, and an insert trigger activates for each inserted ...
https://dev.mysql.com/doc/refman/5.7/en/using-explain.html
That is, MySQL explains how it would process the statement, including information about how tables are joined and in which order. With the help of EXPLAIN, you can see where you should add indexes to tables so that the statement executes faster by ... The EXPLAIN statement provides information about how MySQL executes statements: EXPLAIN works with SELECT, DELETE, INSERT, REPLACE, and UPDATE ...
https://dev.mysql.com/doc/refman/5.7/en/set-password.html
= 'auth_string' syntax is not deprecated, but ALTER USER is the preferred statement for account alterations, including assigning passwords. For example: ALTER USER user IDENTIFIED BY 'auth_string'; Important Under some circumstances, SET PASSWORD ...
https://dev.mysql.com/doc/refman/5.7/en/charset-database.html
The CREATE DATABASE and ALTER DATABASE statements have optional clauses for specifying the database character set and collation: CREATE DATABASE db_name [[DEFAULT] CHARACTER SET charset_name] [[DEFAULT] COLLATE collation_name] ALTER DATABASE db_name ... Every database has a database character set and a database ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-replication.html
On the source, issue the following statement to enable the source to begin processing updates again: mysql> UNLOCK TABLES; A.14.5. Thus, when the update of client A makes it to co-source 2, it produces tables that are different from what you have on ... In the following section, we provide answers to questions that are most frequently asked about MySQL ...