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/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/8.0/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/8.0/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/8.0/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/8.0/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/8.0/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/8.0/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 ...
https://dev.mysql.com/doc/refman/8.0/en/charset-repertoire.html
For the second call, the repertoire is UNICODE because the second argument is outside the ASCII range. IF(column1 < column2, 'smaller', 'greater') The result repertoire is ASCII because the two string arguments (the second argument and the third ...
https://dev.mysql.com/doc/refman/8.0/en/create-event.html
The interval portion consists of two parts, a quantity and a unit of time, and follows the syntax rules described in Temporal Intervals, except that you cannot use any units keywords that involving microseconds when defining an event. For example, ... CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON SLAVE] [COMMENT 'string'] DO event_body; schedule: { AT timestamp [+ INTERVAL interval] ...
https://dev.mysql.com/doc/refman/8.0/en/error-log-configuration.html
Consider this log_error_services value: log_filter_internal; log_sink_1; log_sink_2 In this case, log events pass to the built-in filter, then to the first sink, then to the second sink. Compare that to this log_error_services value: log_sink_1; ...