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/load-data.html
The rules for NULL handling are described later in this section. \Z ASCII 26 (Control+Z) \N NULL For more information about \-escape syntax, see Section 11.1.1, “String Literals”. If the FIELDS ESCAPED BY character is empty, no characters are ...
https://dev.mysql.com/doc/refman/9.7/en/sql-mode.html
If this mode is not enabled, division by zero inserts NULL and produces no warning. If this mode is enabled, division by zero inserts NULL and produces a warning. For INSERT IGNORE and UPDATE IGNORE, division by zero inserts NULL and produces a ...
https://dev.mysql.com/doc/refman/9.7/en/information-functions.html
The result value is 0, or NULL for inappropriate arguments such as a NULL or negative repeat count. CHARSET(str) Returns the character set of the string argument, or NULL if the argument is NULL. mysql> SELECT DATABASE(); -> 'test' If there is no ...
https://dev.mysql.com/doc/refman/9.7/en/outer-join-simplification.html
Instead, MySQL converts the query to a query with no outer join operation if the WHERE condition is null-rejected. (That is, it converts the outer join to an inner join.) A condition is said to be null-rejected for an outer join operation if it ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-ndb-transid-mysql-connection-map-table.html
The ndb_transid_mysql_connection_map table provides a mapping between NDB transactions, NDB transaction coordinators, and MySQL Servers attached to an NDB Cluster as API nodes. This information is used when populating the server_operations and ...
https://dev.mysql.com/doc/refman/9.7/en/index-statistics.html
For a join based on the <=> comparison operator, NULL is not treated differently from any other value: NULL <=> NULL, just as N <=> N for any other N. However, for a join based on the = operator, NULL is different from non-NULL values: expr1 = expr2 ... Storage engines collect statistics about tables for use by the ...
https://dev.mysql.com/doc/refman/9.7/en/json-table-functions.html
This clause is also triggered on a column in a NESTED PATH clause when the latter has no match and a NULL complemented row is produced for it. on empty takes one of the following values: NULL ON EMPTY: The column is set to NULL; this is the default ... This section contains information about JSON functions that convert JSON data to tabular ...
https://dev.mysql.com/doc/refman/9.7/en/create-table-select.html
For example: mysql> CREATE TABLE test (a INT NOT NULL AUTO_INCREMENT, -> PRIMARY KEY (a), KEY(b)) -> ENGINE=InnoDB SELECT b,c FROM test2; This creates an InnoDB table with three columns, a, b, and c. Retrained attributes are NULL (or NOT NULL) and, ... You can create one table from another by adding a SELECT statement at the end of the CREATE TABLE statement: CREATE TABLE new_tbl [AS] SELECT * FROM orig_tbl; MySQL creates new columns for all elements in the ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-information-schema-examples.html
This section describes the use of locking information as exposed by the Performance Schema data_locks and data_lock_waits tables. Identifying Blocking Transactions It is sometimes helpful to identify which transaction blocks another. The tables ...
https://dev.mysql.com/doc/refman/9.7/en/load-xml.html
Suppose that we have a table named person, created as shown here: USE test; CREATE TABLE person ( person_id INT NOT NULL PRIMARY KEY, fname VARCHAR(40) NULL, lname VARCHAR(40) NULL, created TIMESTAMP ); Suppose further that this table is initially ...The tagname in the optional ROWS IDENTIFIED BY clause must also be given as a literal string, and must be surrounded by angle brackets (< and ...