https://dev.mysql.com/set.html
MySQL stores SET values numerically, with the low-order bit of the stored value corresponding to the first set member. If you retrieve a SET value in a numeric context, the value retrieved has bits set corresponding to the set members that make up ... A SET is a string object that can have zero or more values, each of which must be chosen from a list of permitted values specified when the table is ...
https://dev.mysql.com/arithmetic-functions.html
The result is determined according to the following rules: In the case of -, +, and *, the result is calculated with BIGINT (64-bit) precision if both operands are integers. * Multiplication: mysql> SELECT 3*5; -> 15 mysql> SELECT ... Table 12.11 ...
https://dev.mysql.com/audit-log-reference.html
Unless those components are installed, the audit_log plugin operates in legacy mode. MySQL Enterprise Audit uses tables in the mysql system database for persistent storage of filter and user account data. The tables can be accessed only by users ...
https://dev.mysql.com/c-api-prepared-statement-type-conversions.html
For the MYSQL_TYPE_BIT type code, BIT values are returned into a string buffer, which is why the corresponding C type is char[]. The value represents a bit string that requires interpretation on the client side. Prepared statements transmit data ...
https://dev.mysql.com/caching-sha2-pluggable-authentication.html
Note In the name sha256_password, “sha256” refers to the 256-bit digest length the plugin uses for encryption. In the name caching_sha2_password, “sha2” refers more generally to the SHA-2 class of encryption algorithms, of which 256-bit ...
https://dev.mysql.com/character-arrays.html
Each simple character set has a configuration file located in the sql/share/charsets directory. For a character set named MYSYS, the file is named MYSET.xml. <map> elements appear within these elements: <ctype> defines attributes for each character. <collation> elements indicate character ordering for comparison and sorting, one element per ...
https://dev.mysql.com/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/create-tablespace.html
The unique file name is a 128 bit UUID formatted into five groups of hexadecimal numbers separated by dashes (aaaaaaaa-bbbb-cccc-dddd-eeeeeeeeeeee). On 32-bit systems, the maximum supported value for INITIAL_SIZE is 4294967296 (4 GB). The precise ...
https://dev.mysql.com/drop-spatial-reference-system.html
DROP SPATIAL REFERENCE SYSTEM [IF EXISTS] srid srid: 32-bit unsigned integer This statement removes a spatial reference system (SRS) definition from the data dictionary. To identify which column or columns use the SRID, use this query: SELECT * ...
https://dev.mysql.com/encrypted-connection-protocols-ciphers.html
For example, these values do not have holes: tls_version=TLSv1,TLSv1.1,TLSv1.2,TLSv1.3 tls_version=TLSv1.1,TLSv1.2,TLSv1.3 tls_version=TLSv1.2,TLSv1.3 tls_version=TLSv1.3 These values do have holes and should not be used: tls_version=TLSv1,TLSv1.2 ...Supported Connection TLS Protocols Connection TLS Protocol Configuration Connection Cipher Configuration MySQL supports encrypted connections using the TLSv1, TLSv1.1, TLSv1.2, and TLSv1.3 protocols, listed in order from less secure to more ...
