PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/drop-database.html
DROP {DATABASE | SCHEMA} [IF EXISTS] db_name DROP DATABASE drops all tables in the database and deletes the database. If you use DROP DATABASE on a symbolically linked database, both the link and the original database are deleted. The DROP DATABASE ...Be very careful with this statement! To use DROP DATABASE, you need the DROP privilege on the ...
https://dev.mysql.com/doc/refman/8.0/en/drop-role.html
Users who have the DROP ROLE privilege can use this statement only to drop accounts that are locked (unlocked accounts are presumably user accounts used to log in to the server and not just as roles). Roles named in the mandatory_roles system ...
https://dev.mysql.com/doc/refman/8.0/en/drop-view.html
If any views named in the argument list do not exist, the statement fails with an error indicating by name which nonexisting views it was unable to drop, and no changes are made. Note In MySQL 5.7 and earlier, DROP VIEW returns an error if any views ...Due to the change in behavior in MySQL 8.0, a partially completed DROP VIEW operation on a MySQL 5.7 replication source server fails when replicated on a MySQL 8.0 ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-filtering.html
Error log configuration normally includes one log filter component and one or more log sink components. For error log filtering, MySQL offers a choice of components: log_filter_internal: This filter component provides error log filtering based on ...log_filter_dragnet: This filter component provides error log filtering based on user-supplied rules, in combination with the dragnet.log_error_filter_rules system ...
https://dev.mysql.com/doc/refman/8.0/en/estimating-performance.html
For writes, however, you need four seek requests to find where to place a new index value and normally two seeks to update the index and write the row. In MySQL, an index block is usually 1,024 bytes and the data pointer is usually four bytes. This ... In most cases, you can estimate query performance by counting disk ...
https://dev.mysql.com/doc/refman/8.0/en/events-status-info.html
See Section 27.4.6, “The Event Scheduler and MySQL Privileges” for an example. INTO var_list statements, if the query returns no rows, a warning with error code 1329 occurs (No data), and the variable values remain unchanged. For either ... The ...
https://dev.mysql.com/doc/refman/8.0/en/except.html
query_expression_body EXCEPT [ALL | DISTINCT] query_expression_body [EXCEPT [ALL | DISTINCT] query_expression_body] [...] query_expression_body: See Section 15.2.14, “Set Operations with UNION, INTERSECT, and EXCEPT” EXCEPT limits the result ...
https://dev.mysql.com/doc/refman/8.0/en/file-permissions.html
For example, mysqld might issue the following error message when you create a table: ERROR: Can't find file: 'path/with/file_name' (Errcode: 13) The default UMASK and UMASK_DIR values are 0640 and 0750, respectively. If you set its value, new ... If ...
https://dev.mysql.com/doc/refman/8.0/en/foreign-key-optimization.html
If a table has many columns, and you query many different combinations of columns, it might be efficient to split the less-frequently used data into separate tables with a few columns each, and relate them back to the main table by duplicating the ...(To maximize performance, queries try to read as few data blocks as possible from disk; tables with only a few columns can fit more rows in each data ...
https://dev.mysql.com/doc/refman/8.0/en/gis-class-polygon.html
It is defined by a single exterior boundary and zero or more interior boundaries, where each interior boundary defines a hole in the Polygon. Polygon Examples On a region map, Polygon objects could represent forests, districts, and so on. Polygon ...