Search Results
https://dev.mysql.com/doc/internals/en/tracing-example.html
The statement's execution is naturally made of "steps": "steps": [ { "join_preparation": { This is a join's preparation "select#": 1, for the first SELECT of the statement (which has only one, here). "rest_of_plan": [ { "database": "test", "table": ...}, { "access_type": "scan", "using_join_cache": true, "records": 75, "cost": 7.4917, "chosen": false But not table scan, because its amount of records (75) is far greater than that of ref access ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlshow.html
The mysqlshow client can be used to quickly see which databases exist, their tables, or a table's columns or indexes. The same information can be obtained by using those statements directly. For example, you can issue them from the mysql client ...
https://dev.mysql.com/doc/refman/8.4/en/programs-overview.html
MySQL client programs that connect to the MySQL server: mysql The command-line tool for interactively entering SQL statements or executing them from a file in batch mode. mysqlshow A client that displays information about databases, tables, columns, ...Later sections provide a more detailed description of each one, with the exception of NDB Cluster ...
https://dev.mysql.com/doc/refman/8.4/en/windows-restrictions.html
DATA DIRECTORY and INDEX DIRECTORY The DATA DIRECTORY clause of the CREATE TABLE statement is supported on Windows for InnoDB tables only, as described in Section 17.6.1.2, “Creating Tables Externally”. This facility is often used to move the ...
https://dev.mysql.com/doc/workbench/en/wb-what-is-new-60.html
Cascaded DELETE Statements Generator You can generate a series of DELETE statements needed to delete a row from that table, which includes rows from other tables that reference it, recursively. This section summarizes many of the new features added ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-datetime-types-processing.html
This option applies only to prepared statements, callable statements or updatable result sets. This option applies only to prepared statements, callable statements or updatable result sets. connectionTimeZone Configures the connection time zone ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-high-availability-and-clustering.html
Default Value random Since Version 5.0.6 loadBalanceAutoCommitStatementRegex When load-balancing is enabled for auto-commit statements (via 'loadBalanceAutoCommitStatementThreshold'), the statement counter will only increment when the SQL matches ...
https://dev.mysql.com/doc/connectors/en/connector-j-reference-charsets.html
Setting the Character Encoding For Connector/J 8.0.25 and earlier: The character encoding between the client and the server is automatically detected upon connection (provided that the Connector/J connection properties characterEncoding and ...
https://dev.mysql.com/doc/connectors/en/connector-net-8-0-connection-options.html
The Connector/NET options that follow are for general use with connection strings and the options apply to all MySQL server configurations: AllowBatch , Allow Batch Default: true When true, multiple SQL statements can be sent with one command ...
https://dev.mysql.com/doc/connectors/en/connector-net-ref-mysqlclient.html
MySqlCommand Represents an SQL statement to execute against a MySQL database. MySqlScript Provides a class capable of executing an SQL script containing multiple SQL statements including CREATE PROCEDURE statements that require changing the ...