Search Results
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 ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/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 ...
MySQL 8.4 Reference Manual :: A.11 MySQL 8.4 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
https://dev.mysql.com/doc/refman/8.4/en/faqs-cjk.html
Sometimes people try to insert gbk characters into gb2312, and it works most of the time because gbk is a superset of gb2312. But eventually they try to insert a rarer Chinese character and it does not work. mysql> SET sql_mode = ''; mysql> INSERT ... This set of Frequently Asked Questions derives from the experience of MySQL's Support and Development groups in handling many inquiries about CJK (Chinese-Japanese-Korean) ...