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-ndb-comment-options.html
The text of the comment is also available from querying the MySQL Information Schema TABLES table, as in this example: mysql> SELECT TABLE_NAME, TABLE_SCHEMA, TABLE_COMMENT > FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME="t1"\G ... NDB_COLUMN ...
https://dev.mysql.com/doc/refman/8.0/en/dbug-package.html
The MySQL server and most MySQL clients are compiled with the DBUG package originally created by Fred Fish. When you have configured MySQL for debugging, this package makes it possible to get a trace file of what the program is doing. This section ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-natural-language.html
To achieve this result, specify MATCH() twice: once in the SELECT list and once in the WHERE clause. By default or with the IN NATURAL LANGUAGE MODE modifier, the MATCH() function performs a natural language search for a string against a text ...
https://dev.mysql.com/doc/refman/8.0/en/gis-point-property-functions.html
mysql> SET @pt = ST_GeomFromText('POINT(45 90)', 4326); mysql> SELECT ST_Latitude(@pt); +------------------+ | ST_Latitude(@pt) | +------------------+ | 45 | +------------------+ mysql> SELECT ST_AsText(ST_Latitude(@pt, 10)); ... A Point consists of ...
https://dev.mysql.com/doc/refman/8.0/en/gtid-functions.html
The GTID sets used with this function are represented as strings, as shown in the following examples: mysql> SELECT GTID_SUBSET('3E11FA47-71CA-11E1-9E33-C80AA9429562:23', -> '3E11FA47-71CA-11E1-9E33-C80AA9429562:21-57')\G *************************** ... The functions described in this section are used with GTID-based ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-views-table.html
VIEW_DEFINITION The SELECT statement that provides the definition of the view. Skip the words before SELECT and skip the words WITH CHECK OPTION. Suppose that the original statement was: CREATE VIEW v AS SELECT s2,s1 FROM t WHERE s1 > 5 ORDER BY s1 ...You must have the SHOW VIEW privilege to access this ...
https://dev.mysql.com/doc/refman/8.0/en/json-table-functions.html
This section contains information about JSON functions that convert JSON data to tabular data. JSON_TABLE(expr, path COLUMNS (column_list) [AS] alias) Extracts data from a JSON document and returns it as a relational table having the specified ...
https://dev.mysql.com/doc/refman/8.0/en/json-validation-functions.html
This means that JSON_SCHEMA_VALID() can return true even when a regular expression pattern is invalid, as shown here: mysql> SELECT JSON_SCHEMA_VALID('{"type":"string","pattern":"("}', '"abc"'); ... Beginning with MySQL 8.0.17, MySQL supports ...
https://dev.mysql.com/doc/refman/8.0/en/local-variable-scope.html
Similarly, the cursor definition in the following procedure contains a SELECT statement that refers to xname. The scope of a local variable is the BEGIN ... The variable can be referred to in blocks nested within the declaring block, except those ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-dict-obj-tree.html
The dict_obj_tree table provides a tree-based view of table information from the dict_obj_info table. This is intended primarily for use in testing, but can be useful in visualizing hierarchies of NDB database objects. This means that you must know ...