PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/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. As Table 8.43, ...
https://dev.mysql.com/doc/refman/9.7/en/create-table.html
| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ... Character data types (CHAR, VARCHAR, the TEXT types, ENUM, SET, and any synonyms) can include CHARACTER SET to specify the character set for the column. BLOB and ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-component-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. As Table 8.52, ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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 ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/en/show-parse-tree.html
SHOW PARSE_TREE select_statement SHOW PARSE_TREE displays a representation of the parse tree for the input SELECT statement, in JSON format. Note This statement is available only in debug builds, or if the MySQL server was built using ...