Search Results
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-spring-config-jdbctemplate.html
*/ private String queryString = "select Name from City " + "where CountryCode = :country order by rand() limit 1"; /** * Retrieve a random city using Spring JDBC access classes. Spring makes extensive use of the Template method design pattern (see ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-spring-config.html
The Spring Framework is a Java-based application framework designed for assisting in application design by providing a way to configure components. The technique used by Spring is a well known design pattern called Dependency Injection (see ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-troubleshooting.html
This section explains the symptoms and resolutions for the most commonly encountered issues with applications using MySQL Connector/J. Questions 16.1: When I try to connect to the database with MySQL Connector/J, I get the following exception: ...
https://dev.mysql.com/doc/connector-j/en/connector-j-WebAuthn-authentication.html
Web Authentication (WebAuthn) enables user authentication for MySQL Server using devices such as smart cards, security keys, and biometric readers. WebAuthn enables passwordless authentication, and can be used for MySQL accounts that use ...
https://dev.mysql.com/doc/refman/8.4/en/added-deprecated-removed.html
Options and Variables Introduced in MySQL 8.4 Options and Variables Deprecated in MySQL 8.4 Options and Variables Removed in MySQL 8.4 This section lists server variables, status variables, and options that were added for the first time, have been ...
https://dev.mysql.com/doc/refman/8.4/en/adding-character-set.html
To find the maximum of the currently used collation IDs, use this query: SELECT MAX(ID) FROM INFORMATION_SCHEMA.COLLATIONS; This step depends on whether you are adding a simple or complex character set. This section discusses the procedure for ...
https://dev.mysql.com/doc/refman/8.4/en/alter-event.html
You cannot use stored routines or loadable functions in such expressions, and you cannot use any table references; however, you can use SELECT FROM DUAL. The syntax for each of the DEFINER, ON SCHEDULE, ON COMPLETION, COMMENT, ENABLE / DISABLE, and ...
https://dev.mysql.com/doc/refman/8.4/en/alter-logfile-group.html
ALTER LOGFILE GROUP logfile_group ADD UNDOFILE 'file_name' [INITIAL_SIZE [=] size] [WAIT] ENGINE [=] engine_name This statement adds an UNDO file named 'file_name' to an existing log file group logfile_group. An ALTER LOGFILE GROUP statement has ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table.html
While the nonunique indexes are disabled, they are ignored for statements such as SELECT and EXPLAIN that otherwise would use them. ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD ...
https://dev.mysql.com/doc/refman/8.4/en/alter-view.html
ALTER [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}] [DEFINER = user] [SQL SECURITY { DEFINER | INVOKER }] VIEW view_name [(column_list)] AS select_statement [WITH [CASCADED | LOCAL] CHECK OPTION] This statement changes the definition of a view, ...