Search Results
https://dev.mysql.com/doc/refman/8.4/en/sql-prepared-statements.html
Typically, database applications process large volumes of almost-identical statements, with only changes to literal or variable values in clauses such as WHERE for queries and deletes, SET for updates, and VALUES for inserts. The parameter values ...
https://dev.mysql.com/doc/workbench/en/wb-develop-sql-editor-table-export-import.html
Export or import tables using a wizard to assist you. Export a Table Note Alternatively, use Section 6.5, “Data Export and Import” to export larger sets of data, such as entire tables and databases. Import into Table Note Alternatively, use ...
https://dev.mysql.com/doc/workbench/en/wb-develop-sql-editor-table-search.html
Find data across a MySQL connection by using the text search feature on any number of tables and schemas. From the schema tree, select the tables, schemas, or both to search and then right-click the highlighted items and click Search Data Table ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-roles-dynamic-privileges.html
Privilege management is an important aspect of managing the security of a MySQL installation. Following the principle of least privilege, a MySQL account should only be granted privileges required to for its legitimate purposes. To facilitate ...A ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-api-definition.html
The [mysqld] and [api] sections in the config.ini file define the behavior of the MySQL servers (SQL nodes) and other applications (API nodes) used to access cluster data. If no computer or host name is provided, any host can use this SQL or API ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-statements.html
Statement objects allow you to execute basic SQL queries and retrieve the results through the ResultSet class, which is described later. Once you have a Statement instance, you can execute a SELECT query by calling the executeQuery(String) method ...To create a Statement instance, you call the createStatement() method on the Connection object you have retrieved using one of the DriverManager.getConnection() or DataSource.getConnection() methods described ...
https://dev.mysql.com/doc/internals/en/optimizer-joins-access-methods.html
Bad join choices can cause more damage than bad choices in single-table searches, so MySQL developers have spent proportionally more time making sure that the tables in a query are joined in an optimal order and that optimal access methods (often ...A combination of a fixed order in which tables are joined and the corresponding table access methods for each table is called query execution plan ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-high-availability-and-clustering.html
autoReconnect Should the driver try to re-establish stale and/or dead connections? If enabled the driver will throw an exception for queries issued on a stale or dead connection, which belong to the current transaction, but will attempt reconnect ...Default Value 3 Since Version 1.1 reconnectAtTxEnd If 'autoReconnect' is set to "true", should the driver attempt reconnections at the end of every transaction? Default Value false Since Version 3.0.10 retriesAllDown When using load balancing or failover, the number of times the driver should cycle through available hosts, attempting to ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-params-api.html
The listing in this section provides information about parameters used in the [mysqld] and [api] sections of a config.ini file for configuring NDB Cluster SQL nodes and API nodes. For detailed descriptions and other additional information about ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locks-set.html
A locking read, an UPDATE, or a DELETE generally set record locks on every index record that is scanned in the processing of an SQL statement. If you have no indexes suitable for your statement and MySQL must scan the entire table to process the ...