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/creating-spatial-columns.html
MySQL provides a standard way of creating spatial columns for geometry types, for example, with CREATE TABLE or ALTER TABLE. Spatial columns are supported for MyISAM, InnoDB, NDB, and ARCHIVE tables. See also the notes about spatial indexes under ...
https://dev.mysql.com/doc/refman/8.0/en/cursors.html
Cursors have these properties: Asensitive: The server may or may not make a copy of its result table Read only: Not updatable Nonscrollable: Can be traversed only in one direction and cannot skip rows Cursor declarations must appear before handler ...
https://dev.mysql.com/doc/refman/8.0/en/displaying-traces.html
Examining a trace in the mysql command-line client can be made less difficult using the pager less command (or your operating platform's equivalent). INTO DUMPFILE is preferable to INTO OUTFILE for this purpose, since the latter escapes newlines.
https://dev.mysql.com/doc/refman/8.0/en/drop-role.html
As of MySQL 8.0.16, users who have the CREATE USER privilege can use this statement to drop accounts that are locked or unlocked. DROP ROLE removes one or more roles (named collections of privileges). To use this statement, you must have the global ...
https://dev.mysql.com/doc/refman/8.0/en/drop-server.html
DROP SERVER [ IF EXISTS ] server_name Drops the server definition for the server named server_name. Dropping a server for a table does not affect any FEDERATED tables that used this connection information when they were created. DROP SERVER is not ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-filtering.html
For error log filtering, MySQL offers a choice of components: log_filter_internal: This filter component provides error log filtering based on log event priority and error code, in combination with the log_error_verbosity and ... Error log ...
https://dev.mysql.com/doc/refman/8.0/en/example-maximum-row.html
Task: Find the number, dealer, and price of the most expensive article.
https://dev.mysql.com/doc/refman/8.0/en/execution-plan-information.html
Depending on the details of your tables, columns, indexes, and the conditions in your WHERE clause, the MySQL optimizer considers many techniques to efficiently perform the lookups involved in an SQL query. A query on a huge table can be performed ...
https://dev.mysql.com/doc/refman/8.0/en/federated-storage-engine-resources.html
The following additional resources are available for the FEDERATED storage engine: A forum dedicated to the FEDERATED storage engine is available at https://forums.mysql.com/list.php?105.
https://dev.mysql.com/doc/refman/8.0/en/gis-class-geometry.html
In MySQL, the SRID value is an integer associated with the geometry value. It is a noninstantiable class but has a number of properties, described in the following list, that are common to all geometry values created from any of the Geometry ...