Search Results
https://dev.mysql.com/doc/refman/8.4/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/8.4/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/8.4/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/8.4/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, ...
https://dev.mysql.com/doc/refman/8.4/en/values.html
The DEFAULT keyword is not supported by VALUES and causes a syntax error, except when it is used to supply values in an INSERT statement. You should also not confuse it with the VALUES() function that refers to column values in INSERT ... In place ... VALUES is a DML statement which returns a set of one or more rows as a ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-affected-rows.html
It returns the number of rows changed, deleted, or inserted by the last statement if it was an UPDATE, DELETE, or INSERT. For REPLACE statements, the affected-rows value is 2 if the new row replaced an old row, because in this case, one row was ...
https://dev.mysql.com/doc/refman/8.4/en/set-operations.html
Result Set Column Names and Data Types Set Operations with TABLE and VALUES Statements Set Operations using DISTINCT and ALL Set Operations with ORDER BY and LIMIT Limitations of Set Operations SQL set operations combine the results of multiple ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndboperation.html
When using insertTuple(), you may also define the search key with setValue(). NdbOperation::insertTuple() Description This method defines the NdbOperation to be an INSERT operation. NdbOperation::read_attr() Description Read an attribute identified ...Beginning with NDB 8.0.30, NdbOperation supports an interpreted code API similar to that implemented by ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/glossary.html
For example, the mysqlbackup command can log into the server being backed up to insert and update data in the progress table and the history table. apply The operation that transforms a raw backup into a prepared backup by incorporating changes that ... These terms are commonly used in information about the MySQL Enterprise Backup ...
https://dev.mysql.com/doc/refman/8.4/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 ...