Search Results
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-spring-config.html
For example, to configure a connection to a MySQL server supporting the world sample database, you might use: <util:map id="dbProps"> <entry key="db.driver" value="com.mysql.cj.jdbc.Driver"/> <entry key="db.jdbcurl" ... The Spring Framework is a ...
https://dev.mysql.com/doc/refman/8.4/en/charset-collation-names.html
UCA-based collations without a version number in the name use the version-4.0.0 UCA weight keys. For example: utf8mb4_0900_ai_ci is based on UCA 9.0.0 weight keys (http://www.unicode.org/Public/UCA/9.0.0/allkeys.txt). utf8mb4_unicode_ci (with no ...
https://dev.mysql.com/doc/refman/8.4/en/cost-model.html
The primary key for the server_cost table is the cost_name column, so it is not possible to create multiple entries for any cost estimate. Increasing this value causes a query plan that compares many keys to become more expensive. The primary key ...
https://dev.mysql.com/doc/refman/8.4/en/document-store-concepts.html
JSON Document Collection CRUD Operations JSON Document A JSON document is a data structure composed of key-value pairs and is the fundamental structure for using MySQL as document store. Mogae", "GovernmentForm": "Republic" }, "demographics": { ...
https://dev.mysql.com/doc/refman/8.4/en/explain-extended.html
row *************************** id: 1 select_type: PRIMARY table: t1 type: index possible_keys: NULL key: PRIMARY key_len: 4 ref: NULL rows: 4 filtered: 100.00 Extra: Using index *************************** 2. row *************************** id: 2 ... The EXPLAIN statement produces extra (“extended”) information that is not part of EXPLAIN output but can be viewed by issuing a SHOW WARNINGS statement following ...
https://dev.mysql.com/doc/refman/8.4/en/grant-tables.html
The attribute value is an array of elements that each have Database and Restrictions keys indicating the name of a restricted database and the applicable restrictions on it (see Section 8.2.12, “Privilege Restriction Using Partial Revokes”). The ... The mysql system database includes several grant tables that contain information about user accounts and the privileges held by ...
https://dev.mysql.com/doc/refman/8.4/en/index-hints.html
index_hint: USE {INDEX|KEY} [FOR {JOIN|ORDER BY|GROUP BY}] ([index_list]) | {IGNORE|FORCE} {INDEX|KEY} [FOR {JOIN|ORDER BY|GROUP BY}] (index_list) index_list: index_name [, index_name] ... row *************************** id: 1 select_type: DELETE ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-ft-config-table.html
The INNODB_FT_CONFIG table has these columns: KEY The name designating an item of metadata for an InnoDB table containing a FULLTEXT index. The key names and their meanings include: optimize_checkpoint_limit: The number of seconds after which an ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-partitions-table.html
PARTITION_METHOD One of the values RANGE, LIST, HASH, LINEAR HASH, KEY, or LINEAR KEY; that is, one of the available partitioning types as discussed in Section 26.2, “Partitioning Types”. SUBPARTITION_METHOD One of the values HASH, LINEAR HASH, ...Each row in this table corresponds to an individual partition or subpartition of a partitioned ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-syntax-warnings.html
SQL Compression Syntax Warnings and Errors for File-Per-Table Tablespaces When innodb_strict_mode is enabled (the default), specifying ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE in CREATE TABLE or ALTER TABLE statements produces the following error if ... This section describes syntax warnings and errors that you may encounter when using the table compression feature with file-per-table tablespaces and general ...