PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 296.4Kb
Man Pages (Zip)
- 401.7Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/create-server.html
The data stored in the table can be used when creating a connection to a FEDERATED table: CREATE TABLE t (s1 INT) ENGINE=FEDERATED CONNECTION='s'; For more information, see Section 18.8, “The FEDERATED Storage Engine”. CREATE SERVER server_name ...
https://dev.mysql.com/doc/refman/8.0/en/create-spatial-reference-system.html
srs_attribute: { NAME 'srs_name' | DEFINITION 'definition' | ORGANIZATION 'org_name' IDENTIFIED BY org_id | DESCRIPTION 'description' } srid, org_id: 32-bit unsigned integer This statement creates a spatial reference system (SRS) definition and ...
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 ...