MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 21 to 30 of 89 total results

https://dev.mysql.com/doc/refman/8.0/en/data-type-defaults.html

Data type specifications can have explicit or implicit default values. A DEFAULT value clause in a data type specification explicitly indicates a default value for a column. Examples: CREATE TABLE t1 ( i INT DEFAULT -1, c VARCHAR(10) DEFAULT '', ...

26.6 Restrictions and Limitations on Partitioning

https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations.html

This section discusses current restrictions and limitations on MySQL partitioning support. The following constructs are not permitted in partitioning expressions: Stored procedures, stored functions, loadable functions, or plugins. For a list of ...

25.5.28 ndb_size.pl — NDBCLUSTER Size Requirement Estimator

https://dev.mysql.com/doc/refman/8.0/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 ...

6.5.1.1 mysql Client Options

https://dev.mysql.com/doc/refman/8.0/en/mysql-command-options.html

mysql supports the following options, which can be specified on the command line or in the [mysql] and [client] groups of an option file. For information about option files used by MySQL programs, see Section 6.2.2.2, “Using Option Files”.

1.2.2 The Main Features of MySQL

https://dev.mysql.com/doc/refman/8.0/en/features.html

This section describes some of the important characteristics of the MySQL Database Software. In most respects, the roadmap applies to all versions of MySQL. Tested with Purify (a commercial memory leakage detector) as well as with Valgrind, a GPL ...

25.3.5 NDB Cluster Example with Tables and Data

https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-example-data.html

Note The information in this section applies to NDB Cluster running on both Unix and Windows platforms. Working with database tables and data in NDB Cluster is not much different from doing so in standard MySQL. There are two key points to keep in ...

14.17.5 Functions That Return JSON Value Attributes

https://dev.mysql.com/doc/refman/8.0/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 ...

11.3 Keywords and Reserved Words

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

17.9.2 InnoDB Page Compression

https://dev.mysql.com/doc/refman/8.0/en/innodb-page-compression.html

InnoDB supports page-level compression for tables that reside in file-per-table tablespaces. Page compression is enabled by specifying the COMPRESSION attribute with CREATE TABLE or ALTER TABLE. Supported Platforms Page compression requires sparse ...

30.4.4.2 The diagnostics() Procedure

https://dev.mysql.com/doc/refman/8.0/en/sys-diagnostics.html

Creates a report of the current server status for diagnostic purposes. This procedure disables binary logging during its execution by manipulating the session value of the sql_log_bin system variable. That is a restricted operation, so the ...

Displaying 21 to 30 of 89 total results