https://dev.mysql.com/alter-table.html
ALTER TABLE tbl_name [alter_specification [, alter_specification] ...] [partition_options] alter_specification: table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ADD [COLUMN] (col_name column_definition,...) | ADD ...
https://dev.mysql.com/bit-functions.html
An alternative is convert them to fixed-length binary strings without delimiters. (The BIT_AND(), BIT_OR(), and BIT_XOR() aggregate functions are described in Section 12.20.1, “Aggregate (GROUP BY) Function Descriptions”.) Prior to MySQL 8.0, ...
https://dev.mysql.com/can-not-connect-to-server.html
The fix in this case is to change the cron job to not remove mysql.sock or to place the socket file somewhere else. A MySQL client on Unix can connect to the mysqld server in two different ways: By using a Unix socket file to connect through a file ...
https://dev.mysql.com/cannot-create.html
One fix is to start mysqld with the --tmpdir option or to add the option to the [mysqld] section of your option file. If you get an error of the following type for some queries, it means that MySQL cannot create a temporary file for the result set ...
https://dev.mysql.com/charset-unicode-ucs2.html
The ucs2 character set has these characteristics: Supports BMP characters only (no support for supplementary characters) Uses a fixed-length 16-bit encoding and requires two bytes per character. In UCS-2, every character is represented by a 2-byte ...
https://dev.mysql.com/charset-unicode-utf32.html
The utf32 character set is fixed length (like ucs2 and unlike utf16). utf32 uses 32 bits for every character, unlike ucs2 (which uses 16 bits for every character), and unlike utf16 (which uses 16 bits for some characters and 32 bits for others).
https://dev.mysql.com/charset-unicode.html
They can be encoded in a fixed-length encoding using 16 bits (2 bytes). The Unicode Standard includes characters from the Basic Multilingual Plane (BMP) and supplementary characters that lie outside the BMP. For information about the Unicode ...
https://dev.mysql.com/choosing-types.html
For high precision, you can always convert to a fixed-point type stored in a BIGINT. For optimum storage, you should try to use the most precise type in all cases. For example, if an integer column is used for values in the range from 1 to 99999, ...
https://dev.mysql.com/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/connection-control-installation.html
The file name suffix differs per platform (for example, .so for Unix and Unix-like systems, .dll for Windows). For example, put these lines in the server my.cnf file (adjust the .so suffix for your platform as necessary): [mysqld] ... This section ...
