PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/audit-log-file-formats.html
For more complete descriptions of second-level hash items, see later in this section. Example: "query": "DELETE FROM t1" query_time The query execution time in microseconds (if the longlong data type is selected) or seconds (if the double data type ... Important The audit_log plugin is deprecated, and is being replaced by the audit_log ...
https://dev.mysql.com/doc/refman/9.7/en/can-not-connect-to-server.html
After any port is closed, it remains in a TIME_WAIT status for 120 seconds. On the Edit menu, click Add Value, and then add the following registry value: Value Name: TcpTimedWaitDelay Data Type: REG_DWORD Value: 30 This sets the number of seconds to ... A MySQL client on Unix can connect to the mysqld server in two different ways: By using a Unix socket file to connect through a file in the file system (default /tmp/mysql.sock), or by using TCP/IP, which connects through a port ...
https://dev.mysql.com/doc/refman/9.7/en/cast-functions.html
If the optional M value is given, it specifies the fractional seconds precision. If the optional M value is given, it specifies the fractional seconds precision. Table 14.15 Cast Functions and Operators Name Description Deprecated BINARY Cast a ...
https://dev.mysql.com/doc/refman/9.7/en/charset-literal.html
This is true even for the second string; the _latin1 introducer does not affect escape processing. Every character string literal has a character set and a collation. For the simple statement SELECT 'string', the string has the connection default ...
https://dev.mysql.com/doc/refman/9.7/en/command-line-options.html
The second instructs mysql to prompt for the password value and to use test as the default database. For example, the following command tells mysqladmin to ping the server 1024 times, sleeping 10 seconds between each ping: mysqladmin --count=1K ...
https://dev.mysql.com/doc/refman/9.7/en/communication-errors.html
It takes more than connect_timeout seconds to obtain a connect packet. The client had been sleeping more than wait_timeout or interactive_timeout seconds without issuing any requests to the server. If connection problems occur such as communication ...
https://dev.mysql.com/doc/refman/9.7/en/data-masking-plugin-functions.html
gen_blacklist(str, dictionary_name, replacement_dictionary_name) Replaces a term present in one dictionary with a term from a second dictionary and returns the replacement term. gen_blocklist(str, dictionary_name, replacement_dictionary_name) ...
https://dev.mysql.com/doc/refman/9.7/en/data-masking-policy-usage.html
Dynamic data masking enables you to conditionally mask column data for specific users or roles. A masking policy is a rule, or set of rules, which determines how a column's data is transformed for access control. A masking policy consists of the ...
https://dev.mysql.com/doc/refman/9.7/en/data-types.html
fsp applies to the TIME, DATETIME, and TIMESTAMP types and represents fractional seconds precision; that is, the number of digits following the decimal point for fractional parts of seconds. MySQL supports SQL data types in several categories: ...
https://dev.mysql.com/doc/refman/9.7/en/date-and-time-type-conversion.html
Conversion of DATETIME and TIMESTAMP values: Conversion to a DATE value takes fractional seconds into account and rounds the time part. To perform the comparison by ignoring the time part of the DATETIME value instead, use the CAST() function in the ... To some extent, you can convert a value from one temporal type to ...