MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 151 to 160 of 161 total results

https://dev.mysql.com/doc/refman/9.7/en/server-status-variables.html

The value is a bitmask; bits are defined in the openssl/ssl.h header file: # define SSL_VERIFY_NONE 0x00 # define SSL_VERIFY_PEER 0x01 # define SSL_VERIFY_FAIL_IF_NO_PEER_CERT 0x02 # define SSL_VERIFY_CLIENT_ONCE 0x04 SSL_VERIFY_PEER indicates that ... The MySQL server maintains many status variables that provide information about its ...

14.16.2 Argument Handling by Spatial Functions

https://dev.mysql.com/doc/refman/9.7/en/spatial-function-argument-handling.html

If a larger value is given, only the lower 32 bits are used. Spatial values, or geometries, have the properties described in Section 13.4.2.2, “Geometry Class”. Specific functions or groups of functions may have additional or different ...

14.16.11 Spatial GeoJSON Functions

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

The srid argument, if given, must be a 32-bit unsigned integer. This section describes functions for converting between GeoJSON documents and spatial values. Feature and FeatureCollection objects are not supported, except that geometry objects are ...

13.4.5 Spatial Reference System Support

https://dev.mysql.com/doc/refman/9.7/en/spatial-reference-systems.html

Earth is a bit shorter in its North-South axis than its East-West axis, so a slightly flattened sphere is more correct, but perfect spheres permit faster calculations. A spatial reference system (SRS) for spatial data is a coordinate-based system ...

13.3.1 String Data Type Syntax

https://dev.mysql.com/doc/refman/9.7/en/string-type-syntax.html

CHAR(0) is also quite nice when you need a column that can take only two values: A column that is defined as CHAR(0) NULL occupies only one bit and can take only the values NULL and '' (the empty string). The string data types are CHAR, VARCHAR, ...

14.3 Type Conversion in Expression Evaluation

https://dev.mysql.com/doc/refman/9.7/en/type-conversion.html

Comparisons between floating-point numbers and large integer values are approximate because the integer is converted to double-precision floating point before comparison, which is not capable of representing all 64-bit integers exactly. When an ...

B.3.4.2 Problems Using DATE Columns

https://dev.mysql.com/doc/refman/9.7/en/using-date.html

When you compare a DATE, TIME, DATETIME, or TIMESTAMP to a constant string with the <, <=, =, >=, >, or BETWEEN operators, MySQL normally converts the string to an internal long integer for faster comparison (and also for a bit more “relaxed” ...

13.3.5 The VECTOR Type

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

VECTOR Supported and Unsupported Functions VECTOR values can be used with the MySQL string functions BIT_LENGTH(), CHAR_LENGTH(), HEX(), LENGTH(), and TO_BASE64(). VECTOR cannot be used as an argument to any of the following types of functions and ... A VECTOR is a structure that can hold up to a specified number of entries N, defined as shown here: VECTOR(N) Each entry is a 4-byte (single-precision) floating-point ...

8.4.1.11 WebAuthn Pluggable Authentication

https://dev.mysql.com/doc/refman/9.7/en/webauthn-pluggable-authentication.html

Client also sends 1-byte capability, with RESIDENT_KEYS bit set to ON (if it is FIDO2 device) or OFF. Note WebAuthn authentication is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition supports an ...

2.3 Installing MySQL on Microsoft Windows

https://dev.mysql.com/doc/refman/9.7/en/windows-installation.html

MySQL is available for Microsoft Windows 64-bit operating systems only. There are different methods to install MySQL on Microsoft Windows: the MSI, the standard binary distribution (packaged as a compressed file) containing all of the necessary ...

Displaying 151 to 160 of 161 total results