Search Results
https://dev.mysql.com/doc/refman/8.4/en/update.html
For information about generated columns, see Section 15.1.20.8, “CREATE TABLE and Generated Columns”. UPDATE is a DML statement that modifies rows in a table. An UPDATE statement can start with a WITH clause to define common table expressions ...The SET clause indicates which columns to modify and the values they should be ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-locks-per-fragment.html
This table also shows the total time spent waiting for locks successfully and unsuccessfully since fragment or table creation, or since the most recent restart. The values shown in all of the columns ex_req, ex_req_imm_ok, ex_wait_ok, ex_wait_fail, ... The locks_per_fragment table provides information about counts of lock claim requests, and the outcomes of these requests on a per-fragment basis, serving as a companion table to operations_per_fragment and ...
https://dev.mysql.com/doc/ndbapi/en/ndb-column.html
Beginning with NDB 8.0.30, you can change the inline size of a blob column in the mysql client by setting BLOB_INLINE_SIZE in a column comment as part of CREATE TABLE or ALTER TABLE. You can increase the blob part size of a blob column to the ...The ...
https://dev.mysql.com/doc/refman/8.4/en/se-csv-repair.html
The CSV storage engine supports the CHECK TABLE and REPAIR TABLE statements to verify and, if possible, repair a damaged CSV table. When running the CHECK TABLE statement, the CSV file is checked for validity by looking for the correct field ...
https://dev.mysql.com/doc/ndbapi/en/ndb-error-codes-application-error.html
Having a table without primary key uses an autoincremented hidden key, i.e. The following list enumerates all NDB errors of type AE (Application error). NDB error code 5002 MySQL error DMEC Error message The process has wrong type. NDB error code ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-filter-definitions.html
The preceding definition can be written like this: { "filter": { "class": [ { "name": [ "connection", "general", "table_access" ] } ] } } Logging Specific Event Subclasses To select specific event subclasses, use an event item containing a name item ...For information about using JSON data in MySQL, see Section 13.5, “The JSON Data ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locks-set.html
If you have no indexes suitable for your statement and MySQL must scan the entire table to process the statement, every row of the table becomes locked, which in turn blocks all inserts by other users to the table. It is important to create good ...
https://dev.mysql.com/doc/internals/en/event-data-for-specific-event-types.html
Here is an example of how to generate an XID event (it occurs whether or not innodb_support_xa is enabled): CREATE TABLE t1 (a INT) ENGINE = INNODB; START TRANSACTION; INSERT INTO t1 VALUES (1); COMMIT; Fixed data part: Empty Variable data part: 8 ...In MySQL 4.0 and 4.1, such events are written only to the first binary log file that mysqld creates after ... The following ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-drop-index.html
Usage ndb_drop_index -c connection_string table_name index -d db_name The statement shown above drops the index named index from the table in the database. Options that can be used with ndb_drop_index are shown in the following table. --database, -d ...It is recommended that you use this utility only as an example for writing NDB API applications—see the Warning later in this section for ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-learn-with-genai.html
| | \n\nFirst, let's integrate the tables into one full table using a `CREATE TABLE ... Identify columns that should be excluded from training and provide a JSON array.\n\n```json | | \nJSON_ARRAY('x0', 'table_1_id', 'table_2_id', 'table_3_id', ...