MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 101 to 110 of 112 total results

https://dev.mysql.com/doc/refman/8.0/en/spatial-type-overview.html

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 hold single geometry values: GEOMETRY POINT LINESTRING POLYGON ...

15.6 Compound Statement Syntax

https://dev.mysql.com/doc/refman/8.0/en/sql-compound-statements.html

A compound statement is a block that can contain other blocks; declarations for variables, condition handlers, and cursors; and flow control constructs such as loops and conditional tests. END compound statement and other statements that can be used ...

10.10.3 Caching of Prepared Statements and Stored Programs

https://dev.mysql.com/doc/refman/8.0/en/statement-caching.html

These might be used in statements specific to stored programs, such as DECLARE CURSOR or flow-control statements such as IF, CASE, and RETURN. For certain statements that a client might execute multiple times during a session, the server converts ...

27.6 Stored Object Access Control

https://dev.mysql.com/doc/refman/8.0/en/stored-objects-security.html

Stored programs (procedures, functions, triggers, and events) and views are defined prior to use and, when referenced, execute within a security context that determines their privileges. The privileges applicable to execution of a stored object are ...

Chapter 27 Stored Objects

https://dev.mysql.com/doc/refman/8.0/en/stored-objects.html

Stored program definitions include a body that may use compound statements, loops, conditionals, and declared variables. This chapter discusses stored database objects that are defined in terms of SQL code that is stored on the server for later ...

10.2.2.3 Optimizing Subqueries with the EXISTS Strategy

https://dev.mysql.com/doc/refman/8.0/en/subquery-optimization-with-exists.html

To help the query optimizer better execute your queries, use these suggestions: Declare a column as NOT NULL if it really is. Certain optimizations are applicable to comparisons that use the IN (or =ANY) operator to test subquery results. This ...

10.15.3 Traceable Statements

https://dev.mysql.com/doc/refman/8.0/en/traceable-statements.html

Statements which are traceable are listed here: SELECT INSERT REPLACE UPDATE DELETE EXPLAIN with any of the preceding statements SET DO DECLARE, CASE, IF, and RETURN as used in stored routines CALL Tracing is supported for both INSERT and REPLACE ...For statements which are prepared and executed in separate steps, preparation and execution are traced ...

15.2.17 UPDATE Statement

https://dev.mysql.com/doc/refman/8.0/en/update.html

If you update a column that has been declared NOT NULL by setting to NULL, an error occurs if strict SQL mode is enabled; otherwise, the column is set to the implicit default value for the column data type and the warning count is incremented.

17.6.1.1 Creating InnoDB Tables

https://dev.mysql.com/doc/refman/8.0/en/using-innodb-tables.html

You can declare an auto-increment column so that ascending values are filled in automatically as rows are inserted: # The value of ID can act like a pointer between related items in different tables. InnoDB tables are created using the CREATE TABLE ...

15.6.5.8 WHILE Statement

https://dev.mysql.com/doc/refman/8.0/en/while.html

Example: CREATE PROCEDURE dowhile() BEGIN DECLARE v1 INT DEFAULT 5; WHILE v1 > 0 DO ... [begin_label:] WHILE search_condition DO statement_list END WHILE [end_label] The statement list within a WHILE statement is repeated as long as the ...

Displaying 101 to 110 of 112 total results