MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 61 to 70 of 74 total results

25.4.3.9 MySQL Server Options and Variables for NDB Cluster

https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-options-variables.html

This means that (for example) a join on an INT column and a BIGINT column also cannot be pushed down. This section provides information about MySQL server options, server and status variables that are specific to NDB Cluster. For general ...

25.5.6 ndb_blob_tool — Check and Repair BLOB and TEXT columns of NDB Cluster Tables

https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-programs-ndb-blob-tool.html

This tool can be used to check for and remove orphaned BLOB column parts from NDB tables, as well as to generate a file listing any orphaned parts. It is sometimes useful in diagnosing and repairing corrupted or damaged NDB tables containing BLOB ...

25.5.29 ndb_size.pl — NDBCLUSTER Size Requirement Estimator

https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-programs-ndb-size-pl.html

This is a Perl script that can be used to estimate the amount of space that would be required by a MySQL database if it were converted to use the NDBCLUSTER storage engine. Unlike the other utilities discussed in this section, it does not require ...

14.17.5 Functions That Return JSON Value Attributes

https://dev.mysql.com/doc/refman/9.7/en/json-attribute-functions.html

The functions in this section return attributes of JSON values. An error occurs if the argument is not a valid JSON document. An empty array, empty object, or scalar value has depth 1. A nonempty array containing only elements of depth 1 or ...

15.2.7.2 INSERT ... ON DUPLICATE KEY UPDATE Statement

https://dev.mysql.com/doc/refman/9.7/en/insert-on-duplicate.html

If you specify an ON DUPLICATE KEY UPDATE clause and a row to be inserted would cause a duplicate value in a UNIQUE index or PRIMARY KEY, an UPDATE of the old row occurs. If column b is also unique, the INSERT is equivalent to this UPDATE statement ...

1.7.2 MySQL Differences from Standard SQL

https://dev.mysql.com/doc/refman/9.7/en/differences-from-ansi.html

The CAST() function does not support cast to REAL or BIGINT. We try to make MySQL Server follow the ANSI SQL standard and the ODBC SQL standard, but MySQL Server performs operations differently in some cases: There are several differences between ...

13.9 Using Data Types from Other Database Engines

https://dev.mysql.com/doc/refman/9.7/en/other-vendor-data-types.html

To facilitate the use of code written for SQL implementations from other vendors, MySQL maps data types as shown in the following table. These mappings make it easier to import table definitions from other database systems into MySQL. If you create ...

28.4.9 The INFORMATION_SCHEMA INNODB_COLUMNS Table

https://dev.mysql.com/doc/refman/9.7/en/information-schema-innodb-columns-table.html

LEN The column length, for example 4 for INT and 8 for BIGINT. For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object Tables”. The INNODB_COLUMNS table has these columns: TABLE_ID An identifier ...

26.2.3 COLUMNS Partitioning

https://dev.mysql.com/doc/refman/9.7/en/partitioning-columns.html

The permitted data types are shown in the following list: All integer types: TINYINT, SMALLINT, MEDIUMINT, INT (INTEGER), and BIGINT. The next two sections discuss COLUMNS partitioning, which are variants on RANGE and LIST partitioning. COLUMNS ...

14.15 Information Functions

https://dev.mysql.com/doc/refman/9.7/en/information-functions.html

LAST_INSERT_ID(), LAST_INSERT_ID(expr) With no argument, LAST_INSERT_ID() returns a BIGINT UNSIGNED (64-bit) value representing the first automatically generated value successfully inserted for an AUTO_INCREMENT column as a result of the most ...It ...

Displaying 61 to 70 of 74 total results