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
Use the CREATE TABLE statement to create a table with a spatial column: CREATE TABLE geom (g GEOMETRY); Use the ALTER TABLE statement to add or drop a spatial column to or from an existing table: ALTER TABLE geom ADD pt POINT; ALTER TABLE geom DROP ... MySQL provides a standard way of creating spatial columns for geometry types, for example, with CREATE TABLE or ALTER ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-plugin-functions.html
Example: mysql> SELECT gen_dictionary('mydict'); +--------------------------+ | gen_dictionary('mydict') | +--------------------------+ | My term | +--------------------------+ mysql> SELECT gen_dictionary('no-such-dict'); ...Prior to MySQL 8.0.19, ...
https://dev.mysql.com/doc/refman/8.0/en/diagnostics-area.html
SQL statements produce diagnostic information that populates the diagnostics area. Standard SQL has a diagnostics area stack, containing a diagnostics area for each nested execution context. Standard SQL also supports GET STACKED DIAGNOSTICS syntax ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-event-fields.html
Filter components may include or drop error events based on priority, except that system events are mandatory and cannot be dropped. Error events intended for the error log contain a set of fields, each of which consists of a key/value pair. An ...
https://dev.mysql.com/doc/refman/8.0/en/example-foreign-keys.html
To demonstrate ON DELETE and ON UPDATE referential actions, drop the child table and recreate it to include ON UPDATE and ON DELETE subclauses with the CASCADE option. MySQL supports foreign keys, which permit cross-referencing related data across ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-fine-tuning.html
To rebuild FULLTEXT indexes for an InnoDB table, use ALTER TABLE with the DROP INDEX and ADD INDEX options to drop and re-create each index. You can exert more control over full-text searching behavior if you have a MySQL source distribution because ...
https://dev.mysql.com/doc/refman/8.0/en/function-resolution.html
To correct this, use DROP FUNCTION to drop the loadable function and CREATE FUNCTION to re-create the loadable function with a different nonconflicting name. MySQL supports built-in (native) functions, loadable functions, and stored functions. This ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-online-upgrade-methods.html
Wait until all data from the old group is propagated to the new group and then drop the asynchronous replication connection and upgrade any missing members. Wait until all data from the old group is propagated to the new group and then drop the ...
https://dev.mysql.com/doc/refman/8.0/en/host-cache.html
This requires the DROP privilege for the Performance Schema host_cache table or the RELOAD privilege. The MySQL server maintains an in-memory host cache that contains information about clients: IP address, host name, and error information. The ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-files-table.html
It is also important to remember that once an extent is used, it cannot be freed again without dropping the data file of which it is a part. For additional information, and examples of creating, dropping, and obtaining information about NDB Cluster ... The FILES table provides information about the files in which MySQL tablespace data is ...