PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.3Kb
Man Pages (Zip)
- 378.3Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
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 ...
https://dev.mysql.com/doc/refman/9.7/en/enum.html
An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation time. See Section 13.3.1, “String Data Type Syntax” for ENUM type syntax and length ...
https://dev.mysql.com/doc/refman/9.7/en/alter-table-generated-columns.html
ALTER TABLE operations permitted for generated columns are ADD, MODIFY, and CHANGE. CREATE TABLE t1 (c1 INT); ALTER TABLE t1 ADD COLUMN c2 INT GENERATED ALWAYS AS (c1 + 1) STORED; The data type and expression of generated columns can be modified.
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 ...
https://dev.mysql.com/doc/refman/9.7/en/compressed-format.html
Compressed storage format is a read-only format that is generated with the myisampack tool. Compressed tables have the following characteristics: Compressed tables take very little disk space. This minimizes disk usage, which is helpful when using ...
https://dev.mysql.com/doc/refman/9.7/en/converting-tables-to-innodb.html
If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines and tips before converting. Note Partitioned MyISAM tables created in previous versions of MySQL are not compatible ...
https://dev.mysql.com/doc/refman/9.7/en/create-table-select.html
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 SELECT. For example: mysql> CREATE ...
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 | ...
https://dev.mysql.com/doc/refman/9.7/en/srjs-session-info.html
For general information about stored routines in MySQL, see Section 27.2, “Using Stored Routines”. The MLE component provides a number of loadable functions for working with MLE user sessions. These functions are listed and described here: ...
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 | ...