Search Results
https://dev.mysql.com/doc/internals/en/implementing-basic-table-scanning.html
Such engines might be used to support SQL queries of logs and other data files that are populated outside of MySQL. The implementation of the methods in this section provide the first steps toward the creation of more advanced storage engines.
https://dev.mysql.com/doc/internals/en/information-schema-optimizer-trace-table.html
TRACE: The trace, in JSON format (see json.org: basically it has scalars (number, string, bool) and structures (either arrays or associative arrays)).
https://dev.mysql.com/doc/internals/en/logging-transactions-rules-for-create-table-select.html
If the TEMPORARY keyword is not used, write CREATE TABLE (without select) + BEGIN + row events + COMMIT to the TC. (Note: currently Bug#47899 breaks this rule) Note: this breaks D-rpl-correct rule, because the slave will have an intermediate state ...(R-log-create-select-statement-format) If logging in statement format (that is, one of the following holds: (1) @@SESSION.binlog_format=STATEMENT; (2) @@SESSION.binlog_format=MIXED and statement is safe): If there is an error, do not write ...
https://dev.mysql.com/doc/x-devapi-userguide/en/crud-ebnf-table-crud-functions.html
TableSelectFunction Table.select() and collection.find() use different methods for sorting results. Table.select() follows the SQL language naming and calls the sort method orderBy(). Use the method sort() to sort the results returned by ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/crud-ebnf-table-crud-functions.html
TableSelectFunction Table.select() and collection.find() use different methods for sorting results. Table.select() follows the SQL language naming and calls the sort method orderBy(). Use the method sort() to sort the results returned by ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/crud-ebnf-table-crud-functions.html
TableSelectFunction Table.select() and collection.find() use different methods for sorting results. Table.select() follows the SQL language naming and calls the sort method orderBy(). Use the method sort() to sort the results returned by ...
https://dev.mysql.com/doc/refman/8.4/en/ansi-diff-select-into-table.html
For example: INSERT INTO tbl_temp2 (fld_id) SELECT tbl_temp1.fld_order_id FROM tbl_temp1 WHERE tbl_temp1.fld_order_id > 100; Alternatively, you can use SELECT ... The same syntax can also be used inside stored routines using cursors and local ...
https://dev.mysql.com/doc/refman/8.4/en/firewall-information-schema-tables.html
The following sections describe the INFORMATION_SCHEMA tables associated with MySQL Enterprise Firewall (see Section 8.4.7, “MySQL Enterprise Firewall”). These tables are available only if the appropriate firewall plugins are enabled.
https://dev.mysql.com/doc/refman/8.4/en/general-information-schema-tables.html
The following sections describe what may be denoted as the “general” set of INFORMATION_SCHEMA tables. These are the tables not associated with particular storage engines, components, or plugins.
https://dev.mysql.com/doc/refman/8.4/en/information-schema-administrable-role-authorizations-table.html
The ADMINISTRABLE_ROLE_AUTHORIZATIONS table provides information about which roles applicable for the current user or role can be granted to other users or roles. The ADMINISTRABLE_ROLE_AUTHORIZATIONS table has these columns: USER The user name ...