Search Results
https://dev.mysql.com/doc/refman/8.4/en/charset-binary-collations.html
The binary collation differs from _bin collations in several respects, discussed in the following sections: The Unit for Comparison and Sorting Character Set Conversion Lettercase Conversion Trailing Space Handling in Comparisons Trailing Space ...
https://dev.mysql.com/doc/refman/8.4/en/date-and-time-literals.html
You can specify a time zone offset when inserting TIMESTAMP and DATETIME values into a table. The value inserted must not have a zero for the month part, the day part, or both parts. Standard SQL and ODBC Date and Time Literals String and Numeric ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/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/8.4/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/8.4/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/8.4/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/8.4/en/ansi-diff-foreign-keys.html
In an SQL statement that inserts, deletes, or updates many rows, foreign key constraints (like unique constraints) are checked row-by-row. In that case, a (child table) row containing such a foreign key can be inserted even though it does not match ...For example, if you define a RESTRICT type constraint, and there is a child row with several parent rows, InnoDB does not permit the deletion of any of the parent ...