Search Results
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-spring-config-connpooling.html
The example below replaces the source configuration that was based on DriverManagerDataSource with DBCP's BasicDataSource. In many situations, such as web applications, there will be a large number of small database transactions. When this is the ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-spring-config-transactional.html
For that purpose, Spring provides a transaction management package that not only replaces JDBC transaction management, but also enables declarative transaction management (configuration instead of code). Spring allows us to add transactions into ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-spring-config.html
The last bean is responsible for actually replacing the placeholders with the property values. The Spring Framework is a Java-based application framework designed for assisting in application design by providing a way to configure components. The ...
https://dev.mysql.com/doc/refman/8.4/en/adding-collation-choosing-id.html
If you upgrade in place, the process replaces the modified files. To add a collation, you must choose an ID value that is not currently used. The range of IDs from 1024 to 2047 is reserved for user-defined collations. The collation ID that you ...
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/alter-event.html
DISABLE ON REPLICA replaces DISABLE ON SLAVE, which is deprecated, and subject to removal in a future version of MySQL. The syntax for each of the DEFINER, ON SCHEDULE, ON COMPLETION, COMMENT, ENABLE / DISABLE, and DO clauses is exactly the same as ...
https://dev.mysql.com/doc/refman/8.4/en/analyze-table.html
ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [, col_name] ... [WITH N BUCKETS] [{MANUAL | AUTO} UPDATE] ANALYZE [NO_WRITE_TO_BINLOG | LOCAL] TABLE tbl_name UPDATE HISTOGRAM ON col_name [USING DATA 'json_data'] ...
https://dev.mysql.com/doc/refman/8.4/en/apis-perl.html
It replaces an older interface called mysqlperl, which should be considered obsolete. The Perl DBI module provides a generic interface for database access. You can write a DBI script that works with many different database engines without change.
https://dev.mysql.com/doc/refman/8.4/en/archive-storage-engine.html
The ARCHIVE engine supports INSERT, REPLACE, and SELECT, but not DELETE or UPDATE. 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 ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-mysql-database.html
This pertains to statements such as INSERT, UPDATE, DELETE, REPLACE, DO, LOAD DATA, SELECT, and TRUNCATE TABLE. The contents of the grant tables in the mysql database can be modified directly (for example, with INSERT or DELETE) or indirectly (for ...