Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-tp-connections-table.html
The tp_connections table contains one row per connection managed by the Thread Pool plugin. The tp_connections table contains the following rows: CONNECTION_ID The connection ID as reported by SELECT CONNECTION_ID(). This column and ...Each row ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-management-exchange.html
Table nt contains no foreign key references, and no other table has any foreign keys that refer to nt. For InnoDB tables, both tables must use the same row format. To determine the row format of an InnoDB table, query ...There are no rows in nt that ...
https://dev.mysql.com/doc/internals/en/closing-a-table.html
When the MySQL server is finished with a table, it will call the [custom-engine.html#custom-engine-api-reference-close close()] method to close file pointers and release any other resources.
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 ...