Search Results
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 ...
MySQL 9.7 Reference Manual :: A.11 MySQL 9.7 FAQ: MySQL Chinese, Japanese, and Korean Character Sets
https://dev.mysql.com/doc/refman/9.7/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. mysql> SET sql_mode = ''; mysql> INSERT INTO ch VALUES ('A汌B','A汌B'); Query OK, 1 row affected, 1 warning (0.00 sec) ...
https://dev.mysql.com/doc/refman/9.7/en/optimizer-hints.html
Examples: SELECT /*+ RESOURCE_GROUP(USR_default) */ name FROM people ORDER BY name; INSERT /*+ RESOURCE_GROUP(Batch) */ INTO t2 VALUES(2); Syntax of the RESOURCE_GROUP hint: RESOURCE_GROUP(group_name) group_name indicates the resource group to which ...The parser recognizes optimizer hint comments after the initial keyword of SELECT, UPDATE, INSERT, REPLACE, and DELETE ... One means of control ...
https://dev.mysql.com/doc/internals/en/replication-correct.html
Specifically: If the slave has a uniqueness constraint (PK or UK), then uniqueness must be guaranteed before a row is inserted on the slave. If a column only exists on the slave (or if application-specific logic ensures that only NULL values are ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbtransaction.html
A pointer to an NdbRecord indicating an attribute (attr_rec) to be inserted. A row (attr_row) of data to be inserted as the attribute. A mask which can be used to filter the columns to be inserted. Return value A const pointer to the NdbOperation ...
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
If the server adds more internal data types that rely on BLOB storage like image manipulation, seeking into complex types in BLOBs, and more types will be added. Topics in this section: Message Structure Message Sequence Common Messages Connection ...
https://dev.mysql.com/doc/refman/9.7/en/partitioning-management-exchange.html
To see how this occurs, first insert a row into e2 that is outside the boundaries of the partition definition for partition p0 of table e. In addition to the ALTER, INSERT, and CREATE privileges usually required for ALTER TABLE statements, you must ...Table nt contains no foreign key references, and no other table has any foreign keys that refer to ...
https://dev.mysql.com/doc/refman/9.7/en/replication-features-differing-tables.html
When inserting a value from a BIT(M) column into a BIT(M') column, where M' > M, the most significant bits of the BIT(M') columns are cleared (set to zero) and the M bits of the BIT(M) value are set as the least significant bits of the BIT(M') ...In ... Source and target tables for replication do not have to be ...
https://dev.mysql.com/doc/refman/9.7/en/replication-options-source.html
If the local value is set, the new value affects AUTO_INCREMENT columns for all tables into which new rows are inserted by the current user for the duration of the session, unless the values are changed during that session. The highest value present ... This section describes the server options and system variables that you can use on replication source ...