MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 11 to 20 of 31 total results

https://dev.mysql.com/doc/refman/9.7/en/alter-table-examples.html

For NDB tables, it is also possible to change the storage type used for a table or column. row *************************** Table: t1 Create Table: CREATE TABLE `t2` ( `c1` int(11) DEFAULT NULL ) /*!50100 TABLESPACE ts_1 STORAGE DISK */ ...

13.7 Data Type Storage Requirements

https://dev.mysql.com/doc/refman/9.7/en/storage-requirements.html

For example, in NDB tables, the TINYINT, SMALLINT, MEDIUMINT, and INTEGER (INT) column types each require 4 bytes storage per record due to the alignment factor. InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type Storage ...

15.7.7.44 SHOW WARNINGS Statement

https://dev.mysql.com/doc/refman/9.7/en/show-warnings.html

mysql> CREATE TABLE t1 (a TINYINT NOT NULL, b CHAR(4)); Query OK, 0 rows affected (0.05 sec) mysql> INSERT INTO t1 VALUES(10,'mysql'), (NULL,'test'), (300,'xyz'); Query OK, 3 rows affected, 3 warnings (0.00 sec) Records: 3 Duplicates: 0 Warnings: 3 ... SHOW WARNINGS [LIMIT [offset,] row_count] SHOW COUNT(*) WARNINGS SHOW WARNINGS is a diagnostic statement that displays information about the conditions (errors, warnings, and notes) resulting from executing a statement in the current ...

27.3.5 JavaScript Stored Programs—Session Information and Options

https://dev.mysql.com/doc/refman/9.7/en/srjs-session-info.html

mle_set_session_state() The MLE component provides this function as a means for determining the rules in effect during the current session for converting MySQL integer types (TINYINT, SMALLINT, MEDIUMINT, INT, BIGINT) and MySQL decimal types ... For ...

30.4.5.20 The version_major() Function

https://dev.mysql.com/doc/refman/9.7/en/sys-version-major.html

This function returns the major version of the MySQL server. Example mysql> SELECT VERSION(), sys.version_major(); +-----------+---------------------+ | VERSION() | sys.version_major() | +-----------+---------------------+ | 9.5.0 | 9 | ...

30.4.5.21 The version_minor() Function

https://dev.mysql.com/doc/refman/9.7/en/sys-version-minor.html

This function returns the minor version of the MySQL server. Example mysql> SELECT VERSION(), sys.version_minor(); +-----------+---------------------+ | VERSION() | sys.version_minor() | +-----------+---------------------+ | 9.4.0 | 4 | ...

30.4.5.22 The version_patch() Function

https://dev.mysql.com/doc/refman/9.7/en/sys-version-patch.html

This function returns the patch release version of the MySQL server. Example mysql> SELECT VERSION(), sys.version_patch(); +-----------+---------------------+ | VERSION() | sys.version_patch() | +-----------+---------------------+ | 9.4.0 | 0 | ...

10.2.1.1 WHERE Clause Optimization

https://dev.mysql.com/doc/refman/9.7/en/where-optimization.html

This section discusses optimizations that can be made for processing WHERE clauses. The examples use SELECT statements, but the same optimizations apply for WHERE clauses in DELETE and UPDATE statements. Note Because work on the MySQL optimizer is ...

25.5.23 ndb_restore — Restore an NDB Cluster Backup

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

The NDB Cluster restoration program is implemented as a separate command-line utility ndb_restore, which can normally be found in the MySQL bin directory. This program reads the files created as a result of the backup and inserts the stored ...

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 ...

Displaying 11 to 20 of 31 total results