MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 61 to 70 of 72 total results

14.16.7.3 LineString and MultiLineString Property Functions

https://dev.mysql.com/doc/refman/9.7/en/gis-linestring-property-functions.html

You can extract particular points of a LineString, count the number of points that it contains, or obtain its length. Unless otherwise specified, functions in this section handle their geometry arguments as follows: If any argument is NULL or any ...

22.3.3 Documents and Collections

https://dev.mysql.com/doc/refman/9.7/en/mysql-shell-tutorial-javascript-documents-collections.html

When you are using MySQL as a Document Store, collections are containers within a schema that you can create, list, and drop. Collections contain JSON documents that you can add, find, update, and remove. The examples in this section use the ...

22.4.3 Documents and Collections

https://dev.mysql.com/doc/refman/9.7/en/mysql-shell-tutorial-python-documents-collections.html

14.9.2 Boolean Full-Text Searches

https://dev.mysql.com/doc/refman/9.7/en/fulltext-boolean.html

The difference is due to how the casts between integers and floats/doubles are performed internally by InnoDB (along with related precision and rounding decisions), and how they are performed elsewhere, such as in the MySQL command-line client or ...

14.6 Numeric Functions and Operators

https://dev.mysql.com/doc/refman/9.7/en/numeric-functions.html

Table 14.8 Numeric Functions and Operators Name Description %, MOD Modulo operator * Multiplication operator + Addition operator - Minus operator - Change the sign of the argument / Division operator ABS() Return the absolute value ACOS() Return ...

1.2.2 The Main Features of MySQL

https://dev.mysql.com/doc/refman/9.7/en/features.html

Data Types Many data types: signed/unsigned integers 1, 2, 3, 4, and 8 bytes long, FLOAT, DOUBLE, CHAR, VARCHAR, BINARY, VARBINARY, TEXT, BLOB, DATE, TIME, DATETIME, TIMESTAMP, YEAR, SET, ENUM, and OpenGIS spatial types. This section describes some ...

15.2.15.8 Derived Tables

https://dev.mysql.com/doc/refman/9.7/en/derived-tables.html

For information about lateral derived tables preceded by the LATERAL keyword, see Section 15.2.15.9, “Lateral Derived Tables”. A derived table is an expression that generates a table within the scope of a query FROM clause. For example, a ...

13.1 Numeric Data Types

https://dev.mysql.com/doc/refman/9.7/en/numeric-types.html

These types include the exact numeric data types (INTEGER, SMALLINT, DECIMAL, and NUMERIC), as well as the approximate numeric data types (FLOAT, REAL, and DOUBLE PRECISION). MySQL also treats REAL as a synonym for DOUBLE PRECISION (a nonstandard ...

13.9 Using Data Types from Other Database Engines

https://dev.mysql.com/doc/refman/9.7/en/other-vendor-data-types.html

To facilitate the use of code written for SQL implementations from other vendors, MySQL maps data types as shown in the following table. These mappings make it easier to import table definitions from other database systems into MySQL. If you create ...

13.1.7 Out-of-Range and Overflow Handling

https://dev.mysql.com/doc/refman/9.7/en/out-of-range-and-overflow.html

When a floating-point or fixed-point column is assigned a value that exceeds the range implied by the specified (or default) precision and scale, MySQL stores the value representing the corresponding endpoint of that range. If no restrictive modes ...

Displaying 61 to 70 of 72 total results