PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/spatial-type-overview.html
MySQL has spatial data types that correspond to OpenGIS classes. The basis for these types is described in Section 11.4.2, “The OpenGIS Geometry Model”. Some spatial data types hold single geometry values: GEOMETRY POINT LINESTRING POLYGON ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-is-consumer-enabled.html
Returns YES or NO to indicate whether a given Performance Schema consumer is enabled, or NULL if the argument is NULL. (Prior to MySQL 5.7.28, the function returns NULL if the argument is not a valid consumer name.) This function accounts for the ...If the argument is not a valid consumer name, an error ...
https://dev.mysql.com/doc/refman/5.7/en/arithmetic-functions.html
(See Section 11.1, “Numeric Data Types”.) / Division: mysql> SELECT 3/5; -> 0.60 Division by zero produces a NULL result: mysql> SELECT 102/(1-1); -> NULL A division is calculated with BIGINT arithmetic only if performed in a context where its ... Table 12.9 Arithmetic Operators Name Description %, MOD Modulo operator * Multiplication operator + Addition operator - Minus operator - Change the sign of the argument / Division operator DIV Integer division The usual arithmetic operators are ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-filter-definitions.html
The following list describes the permitted predefined functions for function items: audit_log_exclude_accounts_is_null() Checks whether the audit_log_exclude_accounts system variable is NULL. For information about using JSON data in MySQL, see ...
https://dev.mysql.com/doc/refman/5.7/en/charset-connection.html
To tell the server to perform no conversion of result sets or error messages, set character_set_results to NULL or binary: SET character_set_results = NULL; SET character_set_results = binary; For more information about character sets and error ...
https://dev.mysql.com/doc/refman/5.7/en/constraint-foreign-key.html
The available referential actions are RESTRICT (the default), CASCADE, SET NULL, and NO ACTION. Foreign keys let you cross-reference related data across tables, and foreign key constraints help keep this spread-out data consistent. MySQL supports ...
https://dev.mysql.com/doc/refman/5.7/en/csv-storage-engine.html
The CSV storage engine stores data in text files using comma-separated values format. The CSV storage engine is always compiled into the MySQL server. To examine the source for the CSV engine, look in the storage/csv directory of a MySQL source ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-types.html
MySQL permits you to store a “zero” value of '0000-00-00' as a “dummy date.” In some cases, this is more convenient than using NULL values, and uses less data and index space. “Zero” date or time values used through Connector/ODBC are ...
https://dev.mysql.com/doc/refman/5.7/en/example-maximum-column-group-row.html
Task: For each article, find the dealer or dealers with the most expensive price. Other possibilities for solving the problem are to use an uncorrelated subquery in the FROM clause or a LEFT JOIN.
https://dev.mysql.com/doc/refman/5.7/en/explain.html
In practice, the DESCRIBE keyword is more often used to obtain information about table structure, whereas EXPLAIN is used to obtain a query execution plan (that is, an explanation of how MySQL would execute a query). The following discussion uses ...