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
Columns with a spatial data type can have an SRID attribute, to explicitly indicate the spatial reference system (SRS) for values stored in the column. MySQL provides a standard way of creating spatial columns for geometry types, for example, with ...
https://dev.mysql.com/doc/refman/8.0/en/cursor-restrictions.html
Server-side cursors are implemented in the C API using the mysql_stmt_attr_set() function. A server-side cursor enables a result set to be generated on the server side, but not transferred to the client except for those rows that the client ...
https://dev.mysql.com/doc/refman/8.0/en/data-dictionary-information-schema.html
When the underlying data dictionary tables store values previously obtained by directory scans (for example, to enumerate database names or table names within databases) or file-opening operations (for example, to read information from .frm files), ...In particular, for each INFORMATION_SCHEMA table that is a view on data dictionary tables: The server no longer must create a temporary table for each query of the INFORMATION_SCHEMA ...
https://dev.mysql.com/doc/refman/8.0/en/data-size.html
Design your tables to minimize their space on the disk. This can result in huge improvements by reducing the amount of data written to and read from disk. Smaller tables normally require less main memory while their contents are being actively ...
https://dev.mysql.com/doc/refman/8.0/en/data-type-defaults.html
Subqueries, parameters, variables, stored functions, and loadable functions are not permitted. Data type specifications can have explicit or implicit default values. A DEFAULT value clause in a data type specification explicitly indicates a default ...
https://dev.mysql.com/doc/refman/8.0/en/data-types.html
For floating-point and fixed-point types, M is the total number of digits that can be stored (the precision). MySQL supports SQL data types in several categories: numeric types, date and time types, string (character and byte) types, spatial types, ...
https://dev.mysql.com/doc/refman/8.0/en/date-and-time-type-syntax.html
TIMESTAMP values are stored as the number of seconds since the epoch ('1970-01-01 00:00:00' UTC). The date and time data types for representing temporal values are DATE, TIME, DATETIME, TIMESTAMP, and YEAR. For the DATE and DATETIME range ...
https://dev.mysql.com/doc/refman/8.0/en/declare-condition.html
Using names for conditions can help make stored program code clearer. DECLARE condition_name CONDITION FOR condition_value condition_value: { mysql_error_code | SQLSTATE [VALUE] sqlstate_value } The DECLARE ... CONDITION statement declares a named ...
https://dev.mysql.com/doc/refman/8.0/en/declare-cursor.html
A stored program may contain multiple cursor declarations, but each cursor declared in a given block must have a unique name. DECLARE cursor_name CURSOR FOR select_statement This statement declares a cursor and associates it with a SELECT statement ...
https://dev.mysql.com/doc/refman/8.0/en/declare.html
The DECLARE statement is used to define various items local to a program: Local variables. END compound statement and must be at its start, before any other statements. Variable and condition declarations must appear before cursor or handler ...