Search Results
https://dev.mysql.com/doc/refman/8.4/en/spatial-type-overview.html
Attempts to insert values with a different SRID produce an error. MySQL has spatial data types that correspond to OpenGIS classes. The basis for these types is described in Section 13.4.2, “The OpenGIS Geometry Model”. Some spatial data types ...
https://dev.mysql.com/doc/refman/8.4/en/statement-caching.html
Table content changes (for example, with INSERT or UPDATE) do not change metadata, nor do SELECT statements. For certain statements that a client might execute multiple times during a session, the server converts the statement to an internal ...
https://dev.mysql.com/doc/refman/8.4/en/stored-objects.html
A trigger is activated when a particular event occurs for the table, such as an insert or update. This chapter discusses stored database objects that are defined in terms of SQL code that is stored on the server for later execution. Stored objects ...
https://dev.mysql.com/doc/refman/8.4/en/string-comparison-functions.html
For example, consider the following table and data: CREATE TABLE foo (bar VARCHAR(10)); INSERT INTO foo VALUES (NULL), (NULL); The query SELECT COUNT(*) FROM foo WHERE bar LIKE '%baz%'; returns 0. Table 14.13 String Comparison Functions and ...
https://dev.mysql.com/doc/refman/8.4/en/subqueries.html
A subquery's outer statement can be any one of: SELECT, INSERT, UPDATE, DELETE, SET, or DO. All subquery forms and operations that the SQL standard requires are supported, as well as a few features that are MySQL-specific. Here is an example of a ...
https://dev.mysql.com/doc/refman/8.4/en/sys-ps-setup-reset-to-default.html
row *************************** status: Resetting: setup_actors INSERT IGNORE INTO performance_schema.setup_actors VALUES ('%', '%', '%') ... Parameters in_verbose BOOLEAN: Whether to display information about each setup stage during procedure ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-object-index.html
The following tables list sys schema objects and provide a short description of each one.
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-prerequisites.html
Before using the sys schema, the prerequisites described in this section must be satisfied. Because the sys schema provides an alternative means of accessing the Performance Schema, the Performance Schema must be enabled for the sys schema to work.
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-progress-reporting.html
The following sys schema views provide progress reporting for long-running transactions: processlist session x$processlist x$session Assuming that the required instruments and consumers are enabled, the progress column of these views shows the ...
https://dev.mysql.com/doc/refman/8.4/en/sys-sys-config.html
To enable debug output without having to set that variable in individual sessions, add the option to the table: mysql> INSERT INTO sys.sys_config (variable, value) VALUES('debug', 'ON'); To change the debug setting in the table, do two things. This ...