PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/srjs-data-arguments.html
String: The CHAR, VARCHAR, TEXT, and BLOB string types are supported. The maximum supported length for a LONGTEXT value is 1073741799 (230 - 24 - 23 - 1) characters; for LONGBLOB, the maximum supported length is 2147483639 (231 - 28 - 1). Most ...
https://dev.mysql.com/doc/refman/9.7/en/string-functions.html
mysql> SELECT LENGTH('text'); -> 4 Note The Length() OpenGIS spatial function is named ST_Length() in MySQL. If the input is a nonbinary (character) string such as a CHAR, VARCHAR, or TEXT value, the return value contains the collation weights for ...For functions that operate on string positions, the first position is numbered ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-file-formats.html
<AUDIT_RECORD> <TIMESTAMP>2019-10-03T14:09:38 UTC</TIMESTAMP> <RECORD_ID>6_2019-10-03T14:06:33</RECORD_ID> <NAME>Query</NAME> <CONNECTION_ID>5</CONNECTION_ID> <STATUS>0</STATUS> <STATUS_CODE>0</STATUS_CODE> <USER>root[root] @ localhost ... Important ...
https://dev.mysql.com/doc/refman/9.7/en/cast-functions.html
For example, the following pairs of definitions are equivalent: CHAR(10) CHARACTER SET binary BINARY(10) VARCHAR(10) CHARACTER SET binary VARBINARY(10) TEXT CHARACTER SET binary BLOB If BINARY is invoked from within the mysql client, binary strings ... Table 14.15 Cast Functions and Operators Name Description Deprecated BINARY Cast a string to a binary string Yes CAST() Cast a value as a certain type CONVERT() Cast a value as a certain type Cast functions and operators enable conversion of values from one data type to ...
https://dev.mysql.com/doc/refman/9.7/en/charset-national.html
These statements are equivalent: SELECT N'some text'; SELECT n'some text'; SELECT _utf8'some text'; MySQL 9.7 interprets the national character set as utf8mb3, which is now deprecated. Standard SQL defines NCHAR or NATIONAL CHAR as a way to ...
https://dev.mysql.com/doc/refman/9.7/en/create-event.html
The comment text, being a string literal, must be surrounded by quotation marks. One way to get around this restriction is to assemble the text of the statement, prepare it, and execute it within a stored procedure; variable parts of the CREATE ...
https://dev.mysql.com/doc/refman/9.7/en/creating-ssl-files-using-openssl.html
This section describes how to use the openssl command to set up SSL certificate and key files for use by MySQL servers and clients. The first example shows a simplified procedure such as you might use from the command line. The first two examples ...
https://dev.mysql.com/doc/refman/9.7/en/creating-ssl-rsa-files-using-mysql.html
MySQL provides these ways to create the SSL certificate and key files and RSA key-pair files required to support encrypted connections using SSL and secure password exchange using RSA over unencrypted connections, if those files are missing: The ...
https://dev.mysql.com/doc/refman/9.7/en/enterprise-encryption-configuring.html
Decryption Support By Component Functions For Legacy Functions By default, the functions provided by the component_enterprise_encryption component do not decrypt encrypted text, or verify signatures, that were produced by the legacy functions ...
https://dev.mysql.com/doc/refman/9.7/en/explain-output.html
For DEPENDENT SUBQUERY, the subquery is re-evaluated only once for each set of different values of the variables from its outer context. For UNCACHEABLE SUBQUERY, the subquery is re-evaluated for each row of the outer context. There is no single ...