PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/json-table-functions.html
JSON_TABLE() supports four types of columns, described in the following list: name FOR ORDINALITY: This type enumerates rows in the COLUMNS clause; the column named name is a counter whose type is UNSIGNED INT, and whose initial value is 1. Saving ... This section contains information about JSON functions that convert JSON data to tabular ...
https://dev.mysql.com/doc/refman/8.0/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. Reserved words are permitted as identifiers if you quote them as described in Section 11.2, ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-schema.html
User intervention is normally not required to create or maintain either of these tables, since both are maintained by the NDB binary log (binlog) injector thread. Even though ndb_binlog_index and ndb_apply_status are created and maintained ...
https://dev.mysql.com/doc/refman/8.0/en/alter-table.html
| ADD [CONSTRAINT [symbol]] UNIQUE [INDEX | KEY] [index_name] [index_type] (key_part,...) [index_option] ... To verify that the table options were changed as intended, use SHOW CREATE TABLE, or query the Information Schema TABLES table. (Introduced ... ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ADD [COLUMN] (col_name column_definition,...) | ADD {INDEX | KEY} [index_name] [index_type] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-ndb-comment-options.html
(Prior to NDB 8.0.30, only MAX_BLOB_PART_SIZE is supported.) Syntax for this option is shown here: COMMENT 'NDB_COLUMN=speclist' speclist := spec[,spec] spec := BLOB_INLINE_SIZE=value | MAX_BLOB_PART_SIZE[={0|1}] BLOB_INLINE_SIZE specifies the ...
https://dev.mysql.com/doc/refman/8.0/en/information-functions.html
The intended use is from within the mysql client, which reports query execution times: mysql> SELECT BENCHMARK(1000000,AES_ENCRYPT('hello','goodbye')); +---------------------------------------------------+ | ...It may be used to time how quickly ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-analyze-table-complexity.html
ANALYZE TABLE complexity for InnoDB tables is dependent on: The number of pages sampled, as defined by innodb_stats_persistent_sample_pages. The number of indexed columns in a table The number of partitions. If a table has no partitions, the number ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlslap.html
The permissible values are read (scan tables), write (insert into tables), key (read primary keys), update (update primary keys), or mixed (half inserts, half scanning selects). --compression-algorithms=value Command-Line Format ... mysqlslap is a ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-hash.html
To partition a table using HASH partitioning, it is necessary to append to the CREATE TABLE statement a PARTITION BY HASH (expr) clause, where expr is an expression that returns an integer. This can simply be the name of a column whose type is one ... Partitioning by HASH is used primarily to ensure an even distribution of data among a predetermined number of ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-list.html
This is done by using PARTITION BY LIST(expr) where expr is a column value or an expression based on a column value and returning an integer value, and then defining each partition by means of a VALUES IN (value_list), where value_list is a ... List ...