PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/gis-data-formats.html
Two standard spatial data formats are used to represent geometry objects in queries: Well-Known Text (WKT) format Well-Known Binary (WKB) format Internally, MySQL stores geometry values in a format that is not identical to either WKT or WKB format.
https://dev.mysql.com/doc/refman/8.0/en/information-functions.html
Beginning with MySQL 8.0.34, this function can be used for the default value of a VARCHAR or TEXT column, as shown in the following CREATE TABLE statement: CREATE TABLE t (c VARCHAR(288) DEFAULT (CURRENT_USER())); DATABASE() Returns the default ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-ft-index-cache-table.html
The INNODB_FT_INDEX_CACHE table provides token information about newly inserted rows in a FULLTEXT index. Before querying it, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-row-format.html
Tables that use the REDUNDANT row format store the first 768 bytes of variable-length column values (VARCHAR, VARBINARY, and BLOB and TEXT types) in the index record within the B-tree node, with the remainder stored on overflow pages. Tables that ...
https://dev.mysql.com/doc/refman/8.0/en/json.html
When the server later must read a JSON value stored in this binary format, the value need not be parsed from a text representation. The space required to store a JSON document is roughly the same as for LONGBLOB or LONGTEXT; see Section 13.7, ...The ...
https://dev.mysql.com/doc/refman/8.0/en/loading-tables.html
You could create a text file pet.txt containing one record per line, with values separated by tabs, and given in the order in which the columns were listed in the CREATE TABLE statement. To represent these in your text file, use \N (backslash, ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-general-options.html
This is often the case when you have large key values for CHAR, VARCHAR, or TEXT columns, because the sort operation needs to store the complete key values as it proceeds. ft_min_word_len and ft_max_word_len indicate the minimum and maximum word ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-delete-all.html
--usage Command-Line Format --usage Display help text and exit; same as --help. In some cases, this can be much faster than DELETE or even TRUNCATE TABLE. Usage ndb_delete_all -c connection_string tbl_name -d db_name This deletes all rows from the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-drop-index.html
--usage Command-Line Format --usage Display help text and exit; same as --help. It is recommended that you use this utility only as an example for writing NDB API applications—see the Warning later in this section for details. Usage ndb_drop_index ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-drop-table.html
--usage Command-Line Format --usage Display help text and exit; same as --help. Usage ndb_drop_table -c connection_string tbl_name -d db_name Options that can be used with ndb_drop_table are shown in the following table. --connect-retries ...