Search Results
https://dev.mysql.com/doc/connector-j/en/connector-j-overview.html
MySQL provides connectivity for client applications developed in the Java programming language with MySQL Connector/J. Connector/J implements the Java Database Connectivity (JDBC) API, as well as a number of value-adding extensions of it. MySQL ...
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. To create a Statement instance, you call the createStatement() method on the Connection object you have ...
https://dev.mysql.com/doc/refman/8.4/en/alter-database.html
alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name | [DEFAULT] ENCRYPTION [=] {'Y' | 'N'} | READ ONLY [=] {DEFAULT | 0 | 1} } ALTER DATABASE enables you to change the overall characteristics of a database. If the database name is omitted, the statement applies to the default ...
https://dev.mysql.com/doc/refman/8.4/en/archive-storage-engine.html
The ARCHIVE storage engine produces special-purpose tables that store large amounts of unindexed data in a very small footprint. To enable this storage engine if you build MySQL from source, invoke CMake with the -DWITH_ARCHIVE_STORAGE_ENGINE ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-setting.html
You can select the binary logging format explicitly by starting the MySQL server with --binlog-format=type. The supported values for type are: STATEMENT causes logging to be statement based. Setting the binary logging format does not activate ...
https://dev.mysql.com/doc/refman/8.4/en/bnl-bka-optimization.html
In MySQL, a Batched Key Access (BKA) Join algorithm is available that uses both index access to the joined table and a join buffer. The BKA algorithm supports inner join, outer join, and semijoin operations, including nested outer joins. Benefits ...
https://dev.mysql.com/doc/refman/8.4/en/change-replication-filter.html
Filters set using this statement differ from those set using the server options in two key respects: The statement does not require restarting the server to take effect, only that the replication SQL thread be stopped using STOP REPLICA SQL_THREAD ...
https://dev.mysql.com/doc/refman/8.4/en/checksum-table.html
[QUICK | EXTENDED] CHECKSUM TABLE reports a checksum for the contents of a table. You can use this statement to verify that the contents are the same before and after a backup, rollback, or other operation that is intended to put the data back to a ...
https://dev.mysql.com/doc/refman/8.4/en/compatibility.html
This section describes how MySQL relates to the ANSI/ISO SQL standards. MySQL Server has many extensions to the SQL standard, and here you can find out what they are and how to use them. You can also find information about functionality missing ...
https://dev.mysql.com/doc/refman/8.4/en/concurrent-inserts.html
If there are multiple INSERT statements, they are queued and performed in sequence, concurrently with the SELECT statements. The results of a concurrent INSERT may not be visible immediately. The concurrent_insert system variable can be set to ...