PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/audit-log-filtering.html
For the filter shown here, that means no logging for new connections from user1@localhost. Note As of MySQL 5.7.13, for audit log filtering to work as described here, the audit log plugin and the accompanying audit tables and functions must be ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-installation.html
To verify plugin installation, examine the Information Schema PLUGINS table or use the SHOW PLUGINS statement (see Section 5.5.2, “Obtaining Server Plugin Information”). This section describes how to install or uninstall MySQL Enterprise Audit, ...
https://dev.mysql.com/doc/refman/5.7/en/automatic-start.html
The following table shows which option groups the server and startup scripts read from option files. This section discusses methods for starting and stopping the MySQL server. Generally, you start the mysqld server in one of these ways: Invoke ...
https://dev.mysql.com/doc/refman/5.7/en/blackhole-storage-engine.html
You can check whether the BLACKHOLE storage engine is available with the SHOW ENGINES statement. The BLACKHOLE storage engine acts as a “black hole” that accepts data but throws it away and does not store it. To examine the source for the ...
https://dev.mysql.com/doc/refman/5.7/en/calculating-days.html
The following example shows how you can use the bit group functions to calculate the number of days per month a user has visited a Web page. CREATE TABLE t1 (year YEAR, month INT UNSIGNED, day INT UNSIGNED); INSERT INTO t1 ...
https://dev.mysql.com/doc/refman/5.7/en/case-sensitivity.html
This example shows that VERSION() returns a string that has a case-insensitive collation, so comparisons are case-insensitive: mysql> SELECT COLLATION(VERSION()); +----------------------+ | COLLATION(VERSION()) | +----------------------+ | ... For ...
https://dev.mysql.com/doc/refman/5.7/en/cast-functions.html
SELECT statement: mysql> CREATE TABLE new_table SELECT CAST('2000-01-01' AS DATE) AS c1; mysql> SHOW CREATE TABLE new_table\G *************************** 1. Table 12.15 Cast Functions and Operators Name Description BINARY Cast a string to a binary ...
https://dev.mysql.com/doc/refman/5.7/en/change-replication-filter.html
The following list shows the CHANGE REPLICATION FILTER options and how they relate to --replicate-* server options: REPLICATE_DO_DB: Include updates based on database name. Multiple replication filtering rules can be created in a single CHANGE ...
https://dev.mysql.com/doc/refman/5.7/en/char.html
The following table illustrates the differences between CHAR and VARCHAR by showing the result of storing various string values into CHAR(4) and VARCHAR(4) columns (assuming that the column uses a single-byte character set such as latin1). The CHAR ...
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-names.html
The following table shows the suffixes used to indicate these characteristics. MySQL collation names follow these conventions: A collation name starts with the name of the character set with which it is associated, generally followed by one or more ...