Search Results
https://dev.mysql.com/doc/refman/8.4/en/multiple-tables.html
The pet table keeps track of which pets you have. If you want to record other information about them, such as events in their lives like visits to the vet or when litters are born, you need another table. What should this table look like? It needs ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-sql-statements.html
However, you can use LIKE to filter queries against the Information Schema ENGINES table, as discussed in the next item. This section discusses several SQL statements that can prove useful in managing and monitoring a MySQL server that is connected ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-tips.html
Queries can be displayed vertically by terminating the query with \G instead of a semicolon. This section provides information about techniques for more effective use of mysql and about mysql operational behavior. Input-Line Editing Disabling ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-info.html
This section discusses obtaining information about existing partitions, which can be done in a number of ways. Methods of obtaining such information include the following: Using the SHOW CREATE TABLE statement to view the partitioning clauses used ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-range-list.html
Adding and dropping of range and list partitions are handled in a similar fashion, so we discuss the management of both sorts of partitioning in this section. For information about working with tables that are partitioned by hash or key, see ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-pruning.html
Some queries using BETWEEN in the WHERE clause can also take advantage of partition pruning. The optimization known as partition pruning is based on a relatively simple concept which can be described as “Do not scan partitions where there can be ...
https://dev.mysql.com/doc/refman/8.4/en/revoke.html
[IGNORE UNKNOWN USER] REVOKE [IF EXISTS] ALL [PRIVILEGES], GRANT OPTION FROM user_or_role [, user_or_role] ... [IGNORE UNKNOWN USER] REVOKE [IF EXISTS] PROXY ON user_or_role FROM user_or_role [, user_or_role] ... [IGNORE UNKNOWN USER] REVOKE [IF ...
https://dev.mysql.com/doc/refman/8.4/en/subquery-materialization.html
The optimizer uses materialization to enable more efficient subquery processing. Materialization speeds up query execution by generating a subquery result as a temporary table, normally in memory. The first time MySQL needs the subquery result, it ...
https://dev.mysql.com/doc/refman/8.4/en/user-resources.html
The following statement changes the query limit for francis to 100: mysql> ALTER USER 'francis'@'localhost' WITH MAX_QUERIES_PER_HOUR 100; The statement modifies only the limit value specified and leaves the account otherwise unchanged. Similarly, ... One means of restricting client use of MySQL server resources is to set the global max_user_connections system variable to a nonzero ...
https://dev.mysql.com/doc/refman/8.4/en/xml-functions.html
Table 14.16 XML Functions Name Description ExtractValue() Extract a value from an XML string using XPath notation UpdateXML() Return replaced XML fragment This section discusses XML and related functionality in MySQL. Note It is possible to obtain ...