https://dev.mysql.com/column-indexes.html
Index Prefixes FULLTEXT Indexes Spatial Indexes Indexes in the MEMORY Storage Engine With col_name(N) syntax in an index specification for a string column, you can create an index that uses only the first N characters of the column. Note Prefix ...
https://dev.mysql.com/create-procedure.html
The COLLATE attribute can be used if preceded by a CHARACTER SET specification. The COMMENT characteristic is a MySQL extension, and may be used to describe the stored routine. The LANGUAGE characteristic indicates the language in which the routine ...To associate the routine explicitly with a given database, specify the name as db_name.sp_name when you create ...
https://dev.mysql.com/creating-tables.html
Use a CREATE TABLE statement to specify the layout of your table: mysql> CREATE TABLE pet (name VARCHAR(20), owner VARCHAR(20), species VARCHAR(20), sex CHAR(1), birth DATE, death DATE); VARCHAR is a good choice for the name, owner, and species ...
https://dev.mysql.com/data-size.html
The compact family of row formats also optimizes CHAR column storage when using a variable-length character set such as utf8mb3 or utf8mb4. With ROW_FORMAT=REDUNDANT, CHAR(N) occupies N × the maximum byte length of the character set. Many languages ... Design your tables to minimize their space on the ...
https://dev.mysql.com/example-auto-increment.html
You can also explicitly assign 0 to the column to generate sequence numbers, unless the NO_AUTO_VALUE_ON_ZERO SQL mode is enabled. For example: INSERT INTO animals (id,name) VALUES(0,'groundhog'); If the column is declared NOT NULL, it is also ...
https://dev.mysql.com/features.html
This section describes some of the important characteristics of the MySQL Database Software. Data Types Many data types: signed/unsigned integers 1, 2, 3, 4, and 8 bytes long, FLOAT, DOUBLE, CHAR, VARCHAR, BINARY, VARBINARY, TEXT, BLOB, DATE, TIME, ...In most respects, the roadmap applies to all versions of ...
https://dev.mysql.com/innodb-information-schema-system-tables.html
The FLAG field provides bit level information about table format and storage characteristics. You can extract metadata about schema objects managed by InnoDB using InnoDB INFORMATION_SCHEMA tables. Traditionally, you would get this type of ...
https://dev.mysql.com/innodb-memcached-internals.html
table_map_delimiter: The character separating the schema name and the table name when you use the @@ notation in a key name to access a key in a specific table. Multiple columns can be specified using the separator character specified in the ... The ...
https://dev.mysql.com/limits-windows.html
The \ path name separator character Path name components in Windows are separated by the \ character, which is also the escape character in MySQL. If the pipe includes the character ^Z / CHAR(24), Windows thinks that it has encountered end-of-file ... The following limitations apply to use of MySQL on the Windows platform: Process memory On Windows 32-bit platforms, it is not possible by default to use more than 2GB of RAM within a single process, including ...
https://dev.mysql.com/multiple-column-indexes.html
MySQL can create composite indexes (that is, indexes on multiple columns). For certain data types, you can index a prefix of the column (see Section 8.3.5, “Column Indexes”). MySQL can use multiple-column indexes for queries that test all the ...
