Search Results
https://dev.mysql.com/doc/refman/8.4/en/sorting-rows.html
You may have noticed in the preceding examples that the result rows are displayed in no particular order. It is often easier to examine query output when the rows are sorted in some meaningful way. This means that the order is undefined for columns ...
https://dev.mysql.com/doc/refman/8.4/en/sys-extract-schema-from-file-name.html
Example mysql> SELECT sys.extract_schema_from_file_name('/usr/local/mysql/data/world/City.ibd'); +---------------------------------------------------------------------------+ | ... Given a file path name, returns the path component that represents ...
https://dev.mysql.com/doc/refman/8.4/en/sys-extract-table-from-file-name.html
Example mysql> SELECT sys.extract_table_from_file_name('/usr/local/mysql/data/world/City.ibd'); +--------------------------------------------------------------------------+ | sys.extract_table_from_file_name('/usr/local/mysql/data/world/City.ibd') | ... Given a file path name, returns the path component that represents the table ...
https://dev.mysql.com/doc/refman/8.4/en/sys-format-path.html
Example mysql> SELECT sys.format_path('/usr/local/mysql/data/world/City.ibd'); +---------------------------------------------------------+ | sys.format_path('/usr/local/mysql/data/world/City.ibd') | ... Given a path name, returns the modified path ...
https://dev.mysql.com/doc/refman/8.4/en/sys-quote-identifier.html
Example mysql> SELECT sys.quote_identifier('plain'); +-------------------------------+ | sys.quote_identifier('plain') | +-------------------------------+ | `plain` | +-------------------------------+ mysql> SELECT sys.quote_identifier('trick`ier'); ... Given a string argument, this function produces a quoted identifier suitable for inclusion in SQL ...
https://dev.mysql.com/doc/refman/8.4/en/two-digit-years.html
For DATETIME, DATE, and TIMESTAMP types, MySQL interprets dates specified with ambiguous year values using these rules: Year values in the range 00-69 become 2000-2069. Such values must be interpreted into 4-digit form because MySQL stores years ...
https://dev.mysql.com/doc/refman/8.4/en/uninstall-component.html
A component provides services that are available to the server and other components; see Section 7.5, “MySQL Components”. It requires the DELETE privilege for the mysql.component system table because it removes the row from that table that ...
https://dev.mysql.com/doc/refman/8.4/en/uninstall-plugin.html
It requires the DELETE privilege for the mysql.plugin system table because it removes the row from that table that registers the plugin. plugin_name must be the name of some plugin that is listed in the mysql.plugin table. The server executes the ...
https://dev.mysql.com/doc/refman/8.4/en/union.html
query_expression_body UNION [ALL | DISTINCT] query_block [UNION [ALL | DISTINCT] query_expression_body] [...] query_expression_body: See Section 15.2.14, “Set Operations with UNION, INTERSECT, and EXCEPT” UNION combines the result from multiple ...
https://dev.mysql.com/doc/refman/8.4/en/using-explain.html
The EXPLAIN statement provides information about how MySQL executes statements: EXPLAIN works with SELECT, DELETE, INSERT, REPLACE, and UPDATE statements. When EXPLAIN is used with an explainable statement, MySQL displays information from the ...