Search Results
https://dev.mysql.com/doc/refman/8.4/en/example-auto-increment.html
You can also explicitly assign 0 to the column to generate sequence numbers, unless the NO_AUTO_VALUE_ON_ZERO SQL mode is enabled. For example: INSERT INTO animals (id,name) VALUES(0,'groundhog'); If the column is declared NOT NULL, it is also ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-system-tables.html
The FLAG field provides bit level information about table format and storage characteristics. You can extract metadata about schema objects managed by InnoDB using InnoDB INFORMATION_SCHEMA tables. Traditionally, you would get this type of ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-column-indexes.html
The index can be used for lookups in queries that specify values in a known range for combinations of last_name and first_name values. MySQL can create composite indexes (that is, indexes on multiple columns). For certain data types, you can index ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-conflict-resolution.html
Requirements Source Column Control Conflict Resolution Control Conflict Resolution Functions Conflict Resolution Exceptions Table Conflict Detection Status Variables Examples When using a replication setup involving multiple sources (including ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-columns-range.html
Each value list used to define a partition contains 3 values in the same order; that is, each value list tuple has the form (INT, INT, CHAR(3)), which corresponds to the data types used by columns a, d, and c (in that order). In addition, changing ... Range columns partitioning is similar to range partitioning, but enables you to define partitions using ranges based on multiple column ...
https://dev.mysql.com/doc/refman/8.4/en/query-attributes.html
Query attribute names are transmitted using the character set indicated by the character_set_client system variable. The most visible part of an SQL statement is the text of the statement. Clients can also define query attributes that apply to the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-gtids-concepts.html
A GTID is represented as a pair of coordinates, separated by a colon character (:), as shown here: GTID = source_id:transaction_id The source_id identifies the originating server. A tagged GTID consists of three parts, separated by colon characters, ... A global transaction identifier (GTID) is a unique identifier created and associated with each transaction committed on the server of origin (the ...
https://dev.mysql.com/doc/refman/8.4/en/scalar-subqueries.html
A scalar subquery is a simple operand, and you can use it almost anywhere a single column value or literal is legal, and you can expect it to have those characteristics that all operands have: a data type, a length, an indication that it can be ...
https://dev.mysql.com/doc/refman/8.4/en/select.html
[WITH ROLLUP]] [LIMIT {[offset,] row_count | row_count OFFSET offset}] [into_option] [FOR {UPDATE | SHARE} [OF tbl_name [, tbl_name] ...] [NOWAIT | SKIP LOCKED] | LOCK IN SHARE MODE] [into_option] into_option: { INTO OUTFILE 'file_name' [CHARACTER ... SELECT [ALL | DISTINCT | DISTINCTROW ] [HIGH_PRIORITY] [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT] [SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS] select_expr [, select_expr] ...
https://dev.mysql.com/doc/refman/8.4/en/show-procedure-code.html
SHOW PROCEDURE CODE proc_name This statement is a MySQL extension that is available only for servers that have been built with debugging support. It displays a representation of the internal implementation of the named stored procedure. A similar ...