Search Results
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-spring-config-jdbctemplate.html
Spring makes extensive use of the Template method design pattern (see Template Method Pattern). Our immediate focus will be on the JdbcTemplate and related classes, specifically NamedParameterJdbcTemplate. The template classes handle obtaining and ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table.html
That is, a table-copying operation always includes at least the concurrency restrictions of LOCK=SHARED (allow queries but not DML). You can further restrict concurrency for operations that support the LOCK clause by specifying LOCK=EXCLUSIVE, which ... ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ADD [COLUMN] (col_name column_definition,...) | ADD {INDEX | KEY} [index_name] [index_type] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/8.4/en/batch-mode.html
You can generate new queries from existing ones that are similar by copying and editing script files. In the previous sections, you used mysql interactively to enter statements and view the results. If you want the script to continue even if some ...
https://dev.mysql.com/doc/refman/8.4/en/charset-collation-information-schema.html
The preceding behavior occurs because the utf8mb3_general_ci collation is not used for INFORMATION_SCHEMA queries when searching for values that correspond to objects represented in the file system. Consider whether a search should match all such ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-generated-columns.html
Generated columns have several use cases, such as these: Virtual generated columns can be used as a way to simplify and unify queries. A complicated condition can be defined as a generated column and referred to from multiple queries on the table to ...Values of a generated column are computed from an expression included in the column ...
https://dev.mysql.com/doc/refman/8.4/en/create-user.html
CREATE USER permits these resource_option values: MAX_QUERIES_PER_HOUR count, MAX_UPDATES_PER_HOUR count, MAX_CONNECTIONS_PER_HOUR count For all accounts named by the statement, these options restrict how many queries, updates, and connections to ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-plugin-usage.html
Creating Views that Display Masked Data If masked data from a table is used for multiple queries, it may be convenient to define a view that produces masked data. That way, applications can select from the view without performing masking in ...
https://dev.mysql.com/doc/refman/8.4/en/derived-tables.html
For information about lateral derived tables preceded by the LATERAL keyword, see Section 15.2.15.9, “Lateral Derived Tables”. A derived table is an expression that generates a table within the scope of a query FROM clause. For example, a ...
https://dev.mysql.com/doc/refman/8.4/en/distinct-optimization.html
Thus, for more details on the optimization possibilities for DISTINCT queries, see Section 10.2.1.17, “GROUP BY Optimization”. DISTINCT combined with ORDER BY needs a temporary table in many cases. Because DISTINCT may use GROUP BY, learn how ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-thread-pool.html
This minimizes the overhead and expense of establishing and tearing down connections as queries are submitted to the MySQL server. By contrast, the Thread Pool operates on the MySQL server side and is designed to manage the execution of inbound ...