https://dev.mysql.com/multiple-tables.html
Given these considerations, the CREATE TABLE statement for the event table might look like this: mysql> CREATE TABLE event (name VARCHAR(20), date DATE, type VARCHAR(15), remark VARCHAR(255)); As with the pet table, it is easiest to load the initial ... The pet table keeps track of which pets you ...
https://dev.mysql.com/mysqlslap.html
--number-char-cols=N, -x N The number of VARCHAR columns to use if --auto-generate-sql is specified. mysqlslap is a diagnostic program designed to emulate client load for a MySQL server and to report the timing of each stage. Invoke mysqlslap like ...
https://dev.mysql.com/charset-conversion.html
If the column has a nonbinary data type (CHAR, VARCHAR, TEXT), its contents should be encoded in the column character set, not some other character set. To convert a binary or nonbinary string column to use a particular character set, use ALTER ...
https://dev.mysql.com/create-table-ndb-table-comment-options.html
In MySQL NDB Cluster, the table comment in a CREATE TABLE or ALTER TABLE statement can also be used to specify an NDB_TABLE option, which consists of one or more name-value pairs, separated by commas if need be, following the string NDB_TABLE=.
https://dev.mysql.com/innodb-information-schema-system-tables.html
You can extract metadata about schema objects managed by InnoDB using InnoDB INFORMATION_SCHEMA tables. Traditionally, you would get this type of information using the techniques from Section 15.16, “InnoDB Monitors”, setting up InnoDB monitors ...
https://dev.mysql.com/static-format.html
It is used when the table contains no variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT). Static-format tables have these characteristics: CHAR and VARCHAR columns are space-padded to the specified column width, although the column type is ...Of the three MyISAM storage formats, static format is the simplest and most secure (least subject to ...
https://dev.mysql.com/mysql-cluster-disk-data-objects.html
NDB Cluster Disk Data storage is implemented using the following objects: Tablespace: Acts as containers for other Disk Data objects. A tablespace contains one or more data files and one or more undo log file groups. Undo log file: Contains undo ...
https://dev.mysql.com/charset-unicode-sets.html
This section describes the collations available for Unicode character sets and their differentiating properties. MySQL supports multiple Unicode character sets: utf8mb4: A UTF-8 encoding of the Unicode character set using one to four bytes per ...
https://dev.mysql.com/faqs-migration.html
The VARCHAR column type now retains trailing spaces in all storage engines. MEMORY tables (formerly known as HEAP tables) can also contain VARCHAR columns. Where can I find information on how to migrate from MySQL 5.7 to MySQL 8.0? A.8.2. How has ...
https://dev.mysql.com/charset-unicode-utf16.html
The utf16 character set is the ucs2 character set with an extension that enables encoding of supplementary characters: For a BMP character, utf16 and ucs2 have identical storage characteristics: same code values, same encoding, same length. For a ...
