PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/create-table.html
| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ... Prior to MySQL 8.0.13, DEFAULT does not apply to the BLOB, TEXT, GEOMETRY, and JSON types. Character data types (CHAR, VARCHAR, the TEXT types, ENUM, SET, and any ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-filter-definitions.html
query_digest([str]) This function has differing behavior depending on whether an argument is given: With no argument, query_digest returns the statement digest value corresponding to the statement literal text in the current event. string_find(text, ...For information about using JSON data in MySQL, see Section 13.5, “The JSON Data ...
https://dev.mysql.com/doc/refman/8.0/en/string-type-syntax.html
The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. For definitions of character string columns (CHAR, VARCHAR, and the TEXT types), MySQL interprets length specifications in character units. Column definitions ...
https://dev.mysql.com/doc/refman/8.0/en/create-index.html
CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name [index_type] ON tbl_name (key_part,...) [index_option] [algorithm_option | lock_option] ... Additionally, BLOB and TEXT columns can be indexed only for InnoDB, MyISAM, and BLACKHOLE tables. This ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-windows-binary.html
To do this, create a new text file in Notepad or another text editor. To do this, create a new text file in Notepad or another text editor and enter the following text: [mysql_cluster] # Options for data node process: ndb-connectstring=198.51.100.10 ...You should also have the MySQL client (mysql.exe) on this ...
https://dev.mysql.com/doc/refman/8.0/en/column-count-limit.html
BLOB and TEXT columns only contribute 9 to 12 bytes toward the row size limit because their contents are stored separately from the rest of the row. You have to change some columns to TEXT or BLOBs mysql> CREATE TABLE t (a VARCHAR(10000), b ... This ...
https://dev.mysql.com/doc/refman/8.0/en/column-indexes.html
Index Prefixes FULLTEXT Indexes Spatial Indexes Indexes in the MEMORY Storage Engine Index Prefixes With col_name(N) syntax in an index specification for a string column, you can create an index that uses only the first N characters of the column.
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-restore.html
These differences can be combined with other schema differences supported by ndb_restore, including changes to blob and text columns requiring the use of staging tables. --fields-optionally-enclosed-by Command-Line Format ... The NDB Cluster ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-top.html
Output is available as plain text or an ASCII graph; you can specify this using the --text (-x) and --graph (-g) options, respectively. This option or --text must be true; both options may be true. (Formerly, the short form for this option was -t, ... ndb_top displays running information in the terminal about CPU usage by NDB threads on an NDB Cluster data ...
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html
activate_all_roles_on_login applies only at login time, and at the beginning of execution for stored programs and views that execute in definer context. A client that authenticates using the InitSecurityContext() function should provide a string ...