Search Results
https://dev.mysql.com/doc/mysql-errors/8.4/en/server-error-reference.html
Error number: 1217; Symbol: ER_ROW_IS_REFERENCED; SQLSTATE: 23000 Message: Cannot delete or update a parent row: a foreign key constraint fails InnoDB reports this error when you try to delete a parent row that has children, and a foreign key ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-conflict-resolution.html
Some types of conflict resolution supported by NDB Cluster (NDB$OLD(), NDB$MAX(), and NDB$MAX_DELETE_WIN(); NDB$MAX_INS() and NDB$MAX_DEL_WIN_INS()) implement this user-defined column as a “timestamp” column (although its type cannot be ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-foreign-keys.html
Referential Actions When an UPDATE or DELETE operation affects a key value in the parent table that has matching rows in the child table, the result depends on the referential action specified by ON UPDATE and ON DELETE subclauses of the FOREIGN KEY ... MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-recattr-vs-ndbrecord.html
*/ if (psop->deleteCurrentTuple()) APIERROR(myTransaction->getNdbError()); processed++; } } if (result < 0) APIERROR(myTransaction->getNdbError()); if (processed !=0) { /* To get here, there are no more cached scan results, * and some row deletes ...
https://dev.mysql.com/doc/refman/8.4/en/partial-revokes.html
It is possible to grant privileges that apply globally if the partial_revokes system variable is enabled. Specifically, for users who have privileges at the global level, partial_revokes enables privileges for specific schemas to be revoked while ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-parameters.html
You might increase this value for a MySQL server with heavy insert, update, and delete activity, or decrease it for a MySQL server with unchanging data used for reporting. innodb_change_buffering Command-Line Format --innodb-change-buffering=value ... InnoDB Startup Options InnoDB System Variables System variables that are true or false can be enabled at server startup by naming them, or disabled by using a --skip- ...
https://dev.mysql.com/doc/x-devapi-userguide/en/working-with-sql-result-sets.html
System.out.println("Rows affected: " + res.getAffectedItemsCount()); } } print_result(mySession.sql("DELETE FROM users WHERE age < 30").execute()); print_result(mySession.sql("SELECT COUNT(*) AS forty FROM users WHERE age = 40").execute()); C++ Code ... When you execute an SQL operation on a Session using the sql() method, an SqlResult is ...
https://dev.mysql.com/doc/ndbapi/en/mccj-using-clusterj-operations.html
For some operations—find, insert, delete, and update—it is more efficient to tell the cluster on which data node the data is physically located, and to have the transaction execute on that data node. You can update additional columns by invoking ...To insert a new row into the table, first create a new instance of ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-table-info.html
Deleted data How many bytes of unreclaimed deleted data there are. Deleted data How many bytes in the data file are deleted (unused). To obtain a description of a MyISAM table or statistics about it, use the commands shown here. The output from ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-filter-definitions.html
READ delete event: DELETE TRUNCATE TABLE insert event: INSERT INSERT ... The filter shown operates like this: The main filter waits for table_access events, either update or delete. If the update or delete table_access event occurs on the temp_1 or ...For information about using JSON data in MySQL, see Section 13.5, “The JSON Data ...