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/proxy-users.html
This enables the external user to be a proxy for the second user; that is, to assume the privileges of the second user: The external user is a “proxy user” (a user who can impersonate or become known as another user). The second user is a ...The ...
https://dev.mysql.com/doc/refman/9.7/en/range-optimization.html
The interval on the second line uses only one key part. Construct the range based on the first and second key parts (f1 = 1 AND f2 > 40). Construct the range based on the first and second key parts (f1 = 2 AND f2 > 40). The range access method uses ...
https://dev.mysql.com/doc/refman/9.7/en/replication-mode-change-online-verify-transactions.html
If you emply a circular replication topology where multiple servers may have write clients, perform the second step for each source-replica connection, until you have completed the full circle. This section explains how to monitor a replication ...
https://dev.mysql.com/doc/refman/9.7/en/replication-multi-source-provision-replica.html
If the sources in the multi-source replication topology have existing data, it can save time to provision the replica with the relevant data before starting replication. In a multi-source replication topology, cloning or copying of the data ...
https://dev.mysql.com/doc/refman/9.7/en/select.html
The preceding example could have been written like this: SELECT CONCAT(last_name,', ',first_name) full_name FROM mytable ORDER BY full_name; However, because the AS is optional, a subtle problem can occur if you forget the comma between two ...
https://dev.mysql.com/doc/refman/9.7/en/server-options.html
If the option is given without a value, the timeout is set to 300 seconds. This option indicates how many seconds the server should wait for the TCP/IP port to become free if it cannot be opened. The value is the maximum number of milliseconds that ... When you start the mysqld server, you can specify program options using any of the methods described in Section 6.2.2, “Specifying Program ...
https://dev.mysql.com/doc/refman/9.7/en/sql-mode.html
TIME_TRUNCATE_FRACTIONAL Control whether rounding or truncation occurs when inserting a TIME, DATE, or TIMESTAMP value with a fractional seconds part into a column having the same type but fewer fractional digits. If the statement inserts or ... The ...
https://dev.mysql.com/doc/refman/9.7/en/stored-program-restrictions.html
Event timings using the intervals YEAR, QUARTER, MONTH, and YEAR_MONTH are resolved in months; those using any other interval are resolved in seconds. There is no way to cause events scheduled to occur at the same second to execute in a given order.
https://dev.mysql.com/doc/refman/9.7/en/sys-ps-trace-thread.html
in_max_runtime DECIMAL(20,2): The maximum number of seconds (which can be fractional) to collect data. Use NULL to collect data for the default of 60 seconds. in_interval DECIMAL(20,2): The number of seconds (which can be fractional) to sleep ...
https://dev.mysql.com/doc/refman/9.7/en/with.html
The second SELECT produces additional rows and recurses by referring to the CTE name in its FROM clause. The first iteration operates on the initial row set (1) and produces 1+1=2; the second iteration operates on the first iteration's row set (2) ... A common table expression (CTE) is a named temporary result set that exists within the scope of a single statement and that can be referred to later within that statement, possibly multiple ...