Search Results
https://dev.mysql.com/doc/refman/8.4/en/replica-logs-status.html
For the connection metadata repository, the following table shows the correspondence between the columns in the mysql.slave_master_info table, the columns displayed by SHOW REPLICA STATUS, and the lines in the deprecated master.info file. A replica ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-usage.html
When the plugin reads each rule from the rules table, it computes a normalized (statement digest) form from the pattern and a digest hash value, and uses them to update the normalized_pattern and pattern_digest columns: mysql> SELECT * FROM ... To ...
https://dev.mysql.com/doc/refman/8.4/en/tracing-example.html
Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE\G *************************** 1. "resulting_clause_is_simple": true, ...row ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-data-structures.html
To receive output column values, set up MYSQL_BIND structures and pass them to mysql_stmt_bind_result(). (In the following discussion, treat any mention of statement parameters for prepared statements as also applying to query attributes.) For ...
https://dev.mysql.com/doc/workbench/en/wb-getting-started-tutorial-creating-a-model.html
Double-click a Column Name cell and the first field defaults to moviesid because (by default) MySQL Workbench appends id to the table name for the initial field. The figure that appears after the table shows all three columns in the movies table.
https://dev.mysql.com/doc/ndbapi/en/mccj-using-clusterj-operations.html
This can be accomplished by calling the Session method newInstance(), as shown here: Employee newEmployee = session.newInstance(Employee.class); Set the Employee instance properties corresponding with the desired employee table columns. The find() ...To insert a new row into the table, first create a new instance of ...
https://dev.mysql.com/doc/relnotes/connector-odbc/en/news-8-0-33.html
(WL #15482) Improved JSON data character support by presenting JSON columns as utf8mb4 strings instead of binary data. This change also affected the following ODBC functions: SQLColumns() result set changes: DATA_TYPE (column #5) and SQL_DATA_TYPE ... Functionality Added or Changed Bugs Fixed Functionality Added or Changed Added a new OCI_CONFIG_PROFILE connection option to define a profile set in OCI_CONFIG_FILE; and it defaults to ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-loading-table-maximum.html
If the tables have more columns, fewer tables can be loaded. See Table 9-1 for the approximate maximum number of columns and tables for each shape. As an illustration, the table shows the maximum number of tables with an average of 100 columns per ...Tip:You can use the MySQL HeatWave Autopilot to verify that there is sufficient memory to load the tables into your MySQL HeatWave ...
https://dev.mysql.com/doc/refman/8.4/en/ansi-diff-foreign-keys.html
The MATCH clause in the SQL standard controls how NULL values in a composite (multiple-column) foreign key are handled when comparing to a primary key in the referenced table. The NDB storage engine requires an explicit unique key (or primary key) ...For example, if you define a RESTRICT type constraint, and there is a child row with several parent rows, InnoDB does not permit the deletion of any of the parent ...
https://dev.mysql.com/doc/refman/8.4/en/derived-condition-pushdown-optimization.html
When the derived table has a GROUP BY and uses no window functions, an outer WHERE condition referencing one or more columns which are not part of the GROUP BY can be pushed down to the derived table as a HAVING condition. When the derived table ...