Search Results
https://dev.mysql.com/doc/refman/9.7/en/spatial-index-optimization.html
MySQL still maintains such indexes, as follows: They are updated for table modifications (INSERT, UPDATE, DELETE, and so forth). MySQL permits creation of SPATIAL indexes on NOT NULL geometry-valued columns (see Section 13.4.10, “Creating Spatial ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/en/srjsapi-sqlresult.html
getAutoIncrementValue(): Retrieves the autogenerated ID used for the most recent insert operation. Calling this method is equivalent to executing LAST_INSERT_ID() in the mysql client. An SqlResult is produced whenever a query is executed using ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/en/sys-revoke-schema-privileges-from-all-accounts-except.html
Revoke specified privileges for all users except those specified with the exclude_users argument. Parameters in_schema_name: (CHAR(255)) Schema name on which the privileges are revoked.
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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 ...