MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 11 to 20 of 93 total results

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

InnoDB Table Storage Requirements NDB Table Storage Requirements Numeric Type Storage Requirements Date and Time Type Storage Requirements String Type Storage Requirements Spatial Type Storage Requirements JSON Storage Requirements The storage ...

14.19.1 Aggregate Function Descriptions

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

This section describes aggregate functions that operate on sets of values. They are often used with a GROUP BY clause to group values into subsets. If you use an aggregate function in a statement containing no GROUP BY clause, it is equivalent to ...

15.1.11 ALTER TABLE Statement

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

ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ADD [COLUMN] (col_name column_definition,...) | ADD {INDEX | KEY} ...

15.1.22 CREATE PROCEDURE and CREATE FUNCTION Statements

https://dev.mysql.com/doc/refman/9.7/en/create-procedure.html

By default, a stored routine is associated with the default database. To associate the routine explicitly with a given database, specify the name as db_name.sp_name when you create it. The CREATE FUNCTION statement is also used in MySQL to support ...

15.1.25 CREATE TABLE Statement

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

| {FULLTEXT | SPATIAL} [INDEX | KEY] [index_name] (key_part,...) [index_option] ... | [CONSTRAINT [symbol]] UNIQUE [INDEX | KEY] [index_name] [index_type] (key_part,...) [index_option] ... (Some valid select or union statement) CREATE TABLE creates ...

26.6 Restrictions and Limitations on Partitioning

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

13.6 Data Type Default Values

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

12.3.5 Column Character Set and Collation

https://dev.mysql.com/doc/refman/9.7/en/charset-column.html

Every “character” column (that is, a column of type CHAR, VARCHAR, a TEXT type, or any synonym) has a column character set and a column collation. CREATE TABLE t1 ( col1 CHAR(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ) CHARACTER SET ...

8.2.3 Grant Tables

https://dev.mysql.com/doc/refman/9.7/en/grant-tables.html

The mysql system database includes several grant tables that contain information about user accounts and the privileges held by them. For information about other tables in the system database, see Section 7.3, “The mysql System Schema”. The ...

B.3.7 Known Issues in MySQL

https://dev.mysql.com/doc/refman/9.7/en/known-issues.html

This section lists known issues in recent versions of MySQL. For information about platform-specific issues, see the installation and debugging instructions in Section 2.1, “General Installation Guidance”, and Section 7.9, “Debugging MySQL”. The following problems are known: Subquery optimization for IN is not as effective as for ...

Displaying 11 to 20 of 93 total results