Search Results
https://dev.mysql.com/doc/refman/8.4/en/json-search-functions.html
The functions in this section perform search or comparison operations on JSON values to extract data from them, report whether data exists at a location within them, or report the path to data within them. JSON_CONTAINS(target, candidate[, path]) ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-selection.html
When a table is created using [LINEAR] HASH or [LINEAR] KEY partitioning and the names of the partitions are not specified, MySQL automatically names the partitions p0, p1, p2, ..., pN-1, where N is the number of partitions. Explicit selection of ...
https://dev.mysql.com/doc/refman/8.4/en/storage-engine-setting.html
When you create a new table, you can specify which storage engine to use by adding an ENGINE table option to the CREATE TABLE statement: -- ENGINE=INNODB not needed unless you have set a different -- default storage engine. CREATE TABLE t1 (i INT) ...You can specify the default engine by using the --default-storage-engine server startup option, or by setting the default-storage-engine option in the my.cnf configuration ...
https://dev.mysql.com/doc/refman/8.4/en/string-type-syntax.html
In some cases, MySQL may change a string column to a type different from that given in a CREATE TABLE or ALTER TABLE statement. Specifying the CHARACTER SET binary attribute for a character string data type causes the column to be created as the ...
https://dev.mysql.com/doc/workbench/en/wb-generating-php.html
The example scenario that follows demonstrates how to create PHP code. After combining the two, the generated PHP code will look like this: <?php $host = "localhost"; $port = 3306; $socket = ""; $user = "nobody"; $password = ""; $dbname = "sakila"; ... MySQL Workbench can be used to generate PHP code with the bundled PHP plugin, by using the Tools, Utilities, Copy as PHP Code menu ...
https://dev.mysql.com/doc/workbench/en/wb-linux-uninstalling.html
Note By default, the Workbench configuration directory is ~username/mysql/workbench/ where "~username" is the path to your user's home directory. Also, uninstalling Workbench does not remove the .mysqlworkbench schema that Workbench creates when ...
https://dev.mysql.com/doc/workbench/en/wb-mac-uninstalling.html
Note By default, the Workbench configuration directory is ~username/Library/Application Support/MySQL/Workbench where "~username" is the path to your user's home directory. Also, uninstalling Workbench does not remove the .mysqlworkbench schema that ... To uninstall MySQL Workbench for macOS, locate MySQL Workbench in the Applications folder, right-click, and select Move to ...
https://dev.mysql.com/doc/connectors/en/connector-cpp-opentelemetry.html
Connector/C++ supports a connection property option, OPT_OPENTELEMETRY, which has these values: OTEL_DISABLED: The connector does not create OpenTelemetry spans or forward the OpenTelemetry context to the server. Spans generated by the connector are ... For applications that use the legacy JDBC API (that is, not X DevAPI or X DevAPI for C) on Linux systems and use OpenTelemetry (OTel) instrumentation, the connector adds query and connection spans to the trace generated by application code and forwards the current OpenTelemetry context to the ...
https://dev.mysql.com/doc/connectors/en/connector-j-reference-dns-srv.html
It is the users' responsibility to provide a full service host name; Connector/J does not append any prefix nor validate the host name structure. The following are examples of valid service host name patterns: foo.domain.local ... Connector/J ...
https://dev.mysql.com/doc/connectors/en/connector-j-upgrading-to-8.0.html
Here are some changes for Connector/J going from 5.1 to 8.0 and beyond, for which adjustments might be required: 3.3.4.1.1 Running on the Java 8 Platform Connector/J 8.0 and beyond is created specifically to run on the Java 8 platform. Upgrading an ...