Search Results
https://dev.mysql.com/doc/refman/9.7/en/jdv-examples.html
If a sub-object has existing records, the INSERT operation is transformed into an UPDATE operation. mysql> INSERT INTO customer_orders_dv VALUES ( '{ "customer_name": "Alice", "_id": 1, "orders": [ {"order_id": 1, "product": "Laptop", "amount": ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-replication-schema.html
The NDB injector is responsible for capturing all the data events within the cluster, and ensures that all events which change, insert, or delete data are recorded in the ndb_binlog_index table. binlog_row_slice_count column The number of slices ...
https://dev.mysql.com/doc/refman/9.7/en/trigger-syntax.html
The trigger acts as an accumulator, summing the values inserted into one of the columns of the table. In this case, the trigger activates before each row inserted into the table. In the example, the trigger body is a simple SET that accumulates into ...Here is a simple example that associates a trigger with a table, to activate for INSERT ... To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in ...
https://dev.mysql.com/doc/refman/9.7/en/replace.html
As with INSERT, if it is not possible to insert the new row into any of these partitions or subpartitions, the REPLACE statement fails with the error Found a row not matching the given partition set. REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name ...| TABLE table_name} value: {expr | DEFAULT} value_list: value [, value] ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-topic-modeling-prepare.html
mysql> CREATE TABLE movies ( description TEXT ); Insert the sample data into the table. INSERT INTO movies (description) VALUES ('In a post-apocalyptic wasteland, a lone survivor named Max seeks vengeance against a ruthless warlord named Immortan ...
https://dev.mysql.com/doc/mysql-ai/9.7/en/mys-ai-aml-topic-modeling-prepare.html
mysql> CREATE TABLE movies ( description TEXT ); Insert the sample data into the table. INSERT INTO movies (description) VALUES ('In a post-apocalyptic wasteland, a lone survivor named Max seeks vengeance against a ruthless warlord named Immortan ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-information-schema-examples.html
The following data_locks and data_lock_waits tables show that: Transaction 77F (executing an INSERT) is waiting for transactions 77E, 77D, and 77B to commit. Transaction 77E (executing an INSERT) is waiting for transactions 77D and 77B to commit.
https://dev.mysql.com/doc/refman/9.7/en/optimizing-myisam-bulk-data-loading.html
LOAD DATA performs the preceding optimization automatically if the MyISAM table into which you insert data is empty. These performance tips supplement the general guidelines for fast inserts in Section 10.2.5.1, “Optimizing INSERT Statements”.
https://dev.mysql.com/doc/x-devapi-userguide/en/creating-documents.html
Once a collection has been created, it can store JSON documents. You store documents by passing a JSON data structure to the Collection.add() function. Some languages have direct support for JSON data, others have an equivalent syntax to represent ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-examples-programming-net.html
This section contains simple examples that demonstrate the use of Connector/ODBC drivers with ODBC.NET. 5.6.7.2.1 Using Connector/ODBC with ODBC.NET and C# (C sharp) The following sample creates a table my_odbc_net and demonstrates its use in C#.