Search Results
https://dev.mysql.com/doc/refman/9.7/en/json-modification-functions.html
If a path identifies an array element, the corresponding value is inserted at that element position, shifting any following values to the right. If a path identifies an array position past the end of an array, the value is inserted at the end of the ... The functions in this section modify JSON values and return the ...
https://dev.mysql.com/doc/refman/9.7/en/miscellaneous-functions.html
ON DUPLICATE KEY UPDATE statement, you can use the VALUES(col_name) function in the UPDATE clause to refer to column values from the INSERT portion of the statement. In other words, VALUES(col_name) in the UPDATE clause refers to the value of ...The ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-install-example-data.html
Note The information in this section applies to NDB Cluster running on both Unix and Windows platforms. Working with database tables and data in NDB Cluster is not much different from doing so in standard MySQL. There are two key points to keep in ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-statement-tables.html
If the request is, for example, an INSERT statement, the Performance Schema refines the instrument name from statement/abstract/Query to statement/sql/insert, which is the final name. If the request is, for example, an INSERT statement, the ...
https://dev.mysql.com/doc/refman/9.7/en/show-grants.html
SHOW GRANTS [FOR user_or_role [USING role [, role] ...]] user_or_role: { user (see Section 8.2.4, “Specifying Account Names”) | role (see Section 8.2.5, “Specifying Role Names”. } This statement displays the privileges and roles that are ...
https://dev.mysql.com/doc/internals/en/x-protocol-messages-messages.html
Topics in this section: Message Structure Message Sequence Common Messages Connection Session Expectations CRUD SQL Result Sets Expressions Data Types This section provides detailed information about how X Protocol defines messages. Message ...
https://dev.mysql.com/doc/x-devapi-userguide/en/working-with-collections-basic-crud.html
The following example shows the basic usage of CRUD operations (see Section 4.3, “Collection CRUD Function Overview” for more details) when working with documents: After establishing a connection to a MySQL Server instance, a new collection that ... Working with collections of documents is straightforward when using X ...
https://dev.mysql.com/doc/refman/9.7/en/binary-varbinary.html
For cases of truncation, to cause an error to occur (rather than a warning) and suppress insertion of the value, use strict SQL mode. Values are right-padded with 0x00 for inserts, and no trailing bytes are removed for retrievals. Example: For a ...
https://dev.mysql.com/doc/refman/9.7/en/blackhole-storage-engine.html
Inserts into a BLACKHOLE table do not store any data, but if statement based binary logging is enabled, the SQL statements are logged and replicated to replica servers. Inserts are performed into the source's table without explicitly setting the ...
https://dev.mysql.com/doc/refman/9.7/en/create-event.html
row *************************** EVENT_NAME: e EVENT_SCHEMA: d EVENT_DEFINITION: INSERT INTO d.t VALUES ROW(NULL, NOW(), FLOOR(RAND()*100)) EVENT_TYPE: RECURRING 1 row in set (0.00 sec) If an event's definer has privileges sufficient to set global ...