PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/audit-log-restrictions.html
Audit plugin data must be aggregated amongst all MySQL servers used with the cluster. Contents of files referenced by statements such as LOAD DATA are not logged. It is possible to use MySQL Enterprise Audit with MySQL NDB Cluster, subject to the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-configuration.html
To enable NDB, you must modify the server's my.cnf configuration file, or start the server with the --ndbcluster option. This MySQL server is a part of the cluster, so it also must know how to access a management node to obtain the cluster ... A ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-adding-instances.html
At this point, the group has one member in it, server s1, which has some data in it. 20.2.1.6.1 Adding a Second Instance In order to add a second instance, server s2, first create the configuration file for it. If you did not have binary logging ...
https://dev.mysql.com/doc/refman/8.0/en/regexp.html
To specify a literal open ( or close parenthesis ) in a regular expression, it must be escaped: mysql> SELECT REGEXP_LIKE('(', '('); ERROR 3692 (HY000): Mismatched parenthesis in regular expression. Match any character (including carriage return and ...This section discusses the functions and operators available for regular expression matching and illustrates, with examples, some of the special characters and constructs that can be used for regular expression ...
https://dev.mysql.com/doc/refman/8.0/en/charset.html
The default MySQL server character set and collation are utf8mb4 and utf8mb4_0900_ai_ci, but you can specify character sets at the server, database, table, column, and string literal levels. To maximize interoperability and future-proofing of your ... MySQL includes character set support that enables you to store data using a variety of character sets and perform comparisons according to a variety of ...
https://dev.mysql.com/doc/refman/8.0/en/precision-math-rounding.html
This section discusses precision math rounding for the ROUND() function and for inserts into columns with exact-value types (DECIMAL and integer). The ROUND() function rounds differently depending on whether its argument is exact or approximate: ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema.html
MySQL 8.0 includes the sys schema, a set of objects that helps DBAs and developers interpret data collected by the Performance Schema. For new installations, the sys schema is installed by default during data directory initialization if you use ...
https://dev.mysql.com/doc/refman/8.0/en/type-conversion.html
For example, to achieve best results when using BETWEEN with date or time values, use CAST() to explicitly convert the values to the desired data type. To prevent this from happening, quote the value, as shown here: mysql> SELECT * FROM t1 WHERE c3 ... When an operator is used with operands of different types, type conversion occurs to make the operands ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-search-ngram.html
The following example demonstrates creating a table with an ngram FULLTEXT index, inserting sample data (Simplified Chinese text), and viewing tokenized data in the Information Schema INNODB_FT_INDEX_CACHE table. The ngram full-text parser is ...To ...
https://dev.mysql.com/doc/refman/8.0/en/spatial-geohash-functions.html
If any SRID argument is not within the range of a 32-bit unsigned integer, an ER_DATA_OUT_OF_RANGE error occurs. The functions in this section enable manipulation of geohash values, which provides applications the capabilities of importing and ...