PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/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/doc/refman/8.0/en/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/doc/refman/8.0/en/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. Note The ucs2 character set is deprecated in MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/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/doc/refman/8.0/en/charset-unicode.html
They can be encoded in a fixed-length encoding using 16 bits (2 bytes). In addition, in MySQL 8.0.30, all collations using the utf8_ prefix are renamed using the prefix utf8mb3_. The Unicode Standard includes characters from the Basic Multilingual ...
https://dev.mysql.com/doc/refman/8.0/en/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/doc/refman/8.0/en/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/doc/refman/8.0/en/constant-folding-optimization.html
row *************************** Level: Note Code: 1003 Message: /* select#1 */ select `test`.`t`.`ti` AS `ti` from `test`.`t` where (`test`.`t`.`ti` = 255) 1 row in set (0.00 sec) Floating- or fixed-point value. Comparisons between constants and ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-foreign-keys.html
The size and sign of fixed precision types such as INTEGER and DECIMAL must be the same. Consequently, BLOB and TEXT columns cannot be included in a foreign key because indexes on those columns must always include a prefix length. MySQL supports ...
https://dev.mysql.com/doc/refman/8.0/en/creating-tables.html
Instead, it is better to store a fixed value such as date of birth. You want a table that contains a record for each of your pets. This can be called the pet table, and it should contain, as a bare minimum, each animal's name. Because the name by ...