PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/spatial-reference-systems.html
The coordinate system on that plane is Cartesian using a length unit (meters, feet, and so forth), rather than degrees of longitude and latitude. Unlike projected SRSs, it is not georeferenced and it does not necessarily represent Earth. MySQL ... A ...
https://dev.mysql.com/doc/refman/8.0/en/view-check-option.html
It also prevents updates to rows for which the WHERE clause is true but the update would cause it to be not true (in other words, it prevents visible rows from being updated to nonvisible rows). In a WITH CHECK OPTION clause for an updatable view, ... The WITH CHECK OPTION clause can be given for an updatable view to prevent inserts to rows for which the WHERE clause in the select_statement is not ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-list.html
The chief difference between the two types of partitioning is that, in list partitioning, each partition is defined and selected based on the membership of a column value in one of a set of value lists, rather than in one of a set of contiguous ...
https://dev.mysql.com/doc/refman/8.0/en/sys-io-global-by-wait-by-latency.html
These views summarize global I/O consumers to display amount of I/O and time waiting for I/O, grouped by event. The io_global_by_wait_by_latency and x$io_global_by_wait_by_latency views have these columns: event_name The I/O event name, with the ...
https://dev.mysql.com/doc/refman/8.0/en/sys-statements-with-full-table-scans.html
By default, rows are sorted by descending percentage of time a full scan was done and descending total latency. The statements_with_full_table_scans and x$statements_with_full_table_scans views have these columns: query The normalized statement ...
https://dev.mysql.com/doc/refman/8.0/en/sys-statements-with-runtimes-in-95th-percentile.html
The statements_with_runtimes_in_95th_percentile and x$statements_with_runtimes_in_95th_percentile views have these columns: query The normalized statement string. These views list statements with runtimes in the 95th percentile. total_latency The ...db The default database for the statement, or NULL if there is ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-calendar.html
Monday Tuesday Wednesday Thursday Friday Saturday Sunday 1 2 3 4 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 There are no dates between October 4 and October 15. Any dates before the cutover are Julian, and any dates following the cutover are ...A calendar applied to dates when it was not actually in use is called ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-routines-table.html
LAST_ALTERED The date and time when the routine was last modified. DATETIME_PRECISION For stored function temporal return values, the fractional seconds precision. The ROUTINES table provides information about stored routines (stored procedures and ...The ROUTINES table does not include built-in (native) functions or loadable ...
https://dev.mysql.com/doc/refman/8.0/en/getting-information.html
What if you forget the name of a database or table, or what the structure of a given table is (for example, what its columns are called)? MySQL addresses this problem through several statements that provide information about the databases and ...
https://dev.mysql.com/doc/refman/8.0/en/sys-host-summary-by-statement-latency.html
The host_summary_by_statement_latency and x$host_summary_by_statement_latency views have these columns: host The host from which the client connected. Rows for which the HOST column in the underlying Performance Schema table is NULL are assumed to ...rows_sent The total number of rows returned by statements for the ...