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/json-validation-functions.html
Both functions handle null or invalid input as follows: If at least one of the arguments is NULL, the function returns NULL. Beginning with MySQL 8.0.17, MySQL supports validation of JSON documents against JSON schemas conforming to Draft 4 of the ...
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. This may also be true for the names of built-in functions. Some keywords which are otherwise ...
https://dev.mysql.com/doc/refman/8.0/en/loading-tables.html
For missing values (such as unknown sexes or death dates for animals that are still living), you can use NULL values. Suppose that Diane gets a new hamster named “Puffball.” You could add a new record using an INSERT statement like this: mysql> ...Suppose that your pet records can be described as shown ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-column-indexes.html
MySQL can create composite indexes (that is, indexes on multiple columns). For certain data types, you can index a prefix of the column (see Section 10.3.5, “Column Indexes”). MySQL can use multiple-column indexes for queries that test all the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-transactions.html
A number of limitations exist in NDB Cluster with regard to the handling of transactions. The NDBCLUSTER storage engine supports only the READ COMMITTED transaction isolation level. To ensure that a given transaction reads only before or after ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbd-definition.html
Consider this table definition: CREATE TABLE example ( a INT NOT NULL, b INT NOT NULL, c INT NOT NULL, PRIMARY KEY(a), UNIQUE(b) ) ENGINE=NDBCLUSTER; For each record, there are 12 bytes of data plus 12 bytes overhead. The [ndbd] and [ndbd default] ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-import.html
--output-type=name Command-Line Format --output-type=name Type Enumeration Default Value ndb Valid Values null Set the output type. ndb_import imports CSV-formatted data, such as that produced by mysqldump --tab, directly into NDB using the NDB API. ndb_import requires a connection to an NDB management server (ndb_mgmd) to function; it does not require a connection to a MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-select-all.html
ndb_select_all prints all rows from an NDB table to stdout. Usage ndb_select_all -c connection_string tbl_name -d db_name [> file_name] Options that can be used with ndb_select_all are shown in the following table. --connect-retries Command-Line ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-logging.html
Then use either of the following techniques to prevent it from being created again: Set the MYSQL_HISTFILE environment variable to /dev/null. Create .mysql_history as a symbolic link to /dev/null; this need be done only once: ln -s /dev/null ... The ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-javascript-documents-in-tables.html
In MySQL, a table may contain traditional relational data, JSON values, or both. You can combine traditional data with JSON documents by storing the documents in columns having a native JSON data type. Examples in this section use the city table in ...