MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 11 to 20 of 89 total results

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

1.3 What Is New in MySQL 8.0

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

This section summarizes what has been added to, deprecated in, and removed from MySQL 8.0. A companion section lists MySQL server options and variables that have been added, deprecated, or removed in MySQL 8.0; see Section 1.4, “Server and Status ...

14.19.1 Aggregate Function Descriptions

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

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

B.3.7 Known Issues in MySQL

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

14.10 Cast Functions and Operators

https://dev.mysql.com/doc/refman/8.0/en/cast-functions.html

Table 14.15 Cast Functions and Operators Name Description Deprecated BINARY Cast a string to a binary string Yes CAST() Cast a value as a certain type CONVERT() Cast a value as a certain type Cast functions and operators enable conversion of values ...

8.2.3 Grant Tables

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

6.6.6 myisampack — Generate Compressed, Read-Only MyISAM Tables

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

When the table is used later, the server reads into memory the information needed to decompress columns. This results in much better performance when accessing individual rows, because you only have to uncompress exactly one row. MySQL uses mmap() ...

12.3.5 Column Character Set and Collation

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

15.1.17 CREATE PROCEDURE and CREATE FUNCTION Statements

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

Displaying 11 to 20 of 89 total results