Search Results
https://dev.mysql.com/doc/refman/9.7/en/switchable-optimizations.html
For more information, see Section 10.2.2.5, “Derived Condition Pushdown Optimization” Derived Table Merging Flags derived_merge (default on) Controls merging of derived tables and views into outer query block. The derived_merge flag controls ...
https://dev.mysql.com/doc/refman/9.7/en/explain.html
Obtaining Execution Plan Information The EXPLAIN statement provides information about how MySQL executes statements: EXPLAIN works with SELECT, DELETE, INSERT, REPLACE, UPDATE, and TABLE statements. MySQL 9.7 supports an additional INTO option with ...In practice, the DESCRIBE keyword is more often used to obtain information about table structure, whereas EXPLAIN is used to obtain a query execution plan (that is, an explanation of how MySQL would execute a ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-tracing-mysql.html
mysql Information: 1 : 1: Connection Opened: connection string = 'server=localhost;User Id=root;database=world;port=3306 ;password=******;logging=True' mysql Information: 3 : 1: Query Opened: SHOW VARIABLES mysql Information: 4 : 1: Resultset ...
https://dev.mysql.com/doc/ndbapi/en/ndb-error-codes-application-error.html
The following list enumerates all NDB errors of type AE (Application error). Having a table without primary key uses an autoincremented hidden key, i.e. NDB error code 5002 MySQL error DMEC Error message The process has wrong type. NDB error code ...
https://dev.mysql.com/doc/relnotes/connector-net/en/news-8-0-28.html
(WL #14653) Bugs Fixed An insert query could emit a malformed communication packet error. (Bug #81586, Bug #23343947) Batch inserts that exceeded the max_allowed_packet value were not processed and skipping the insert attempt did not emit an error.
https://dev.mysql.com/doc/refman/9.7/en/json-duality-views-updatable.html
DML enables seamless INSERT, UPDATE, and DELETE operations directly in developer-friendly JSON documents while ensuring data consistency through the underlying relational schema. JSON duality views introduces modification tags, which are annotations ...DML operations on JSON duality views involves several orchestrated steps working together: Document validation: The JSON duality view automatically validates the input JSON document for correct syntax and ensures it matches the expected ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-shell-tutorial-javascript-documents-modify.html
mysql-js> db.countryinfo.modify("Name = 'France'").arrayInsert("$.Airports[0]", "CDG") To delete an element from the array, you must pass to the arrayDelete() method the index of the element to be deleted. You can use the modify() method to update ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-shell-tutorial-python-documents-modify.html
mysql-py> db.countryinfo.modify("Name = 'France'").array_insert("$.Airports[0]", "CDG") To delete an element from the array, you must pass to the array_delete() method the index of the element to be deleted. You can use the modify() method to ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-table-wait-summary-tables.html
For example, columns that aggregate all writes hold the sum of the corresponding columns that aggregate inserts, updates, and deletes. They are the same as the sum of the corresponding xxx_INSERT, xxx_UPDATE, and xxx_DELETE columns. COUNT_INSERT, ...
https://dev.mysql.com/doc/refman/9.7/en/roles.html
To restore modification privileges to the role, simply re-grant them: GRANT INSERT, UPDATE, DELETE ON app_db.* TO 'app_write'; Now rw_user1 again has modification privileges, as do any other accounts granted the app_write role. Like user accounts, ...