Search Results
https://dev.mysql.com/doc/refman/8.4/en/bit-type.html
The BIT data type is used to store bit values. If you assign a value to a BIT(M) column that is less than M bits long, the value is padded on the left with zeros. For example, assigning a value of b'101' to a BIT(6) column is, in effect, the same ...
https://dev.mysql.com/doc/refman/8.4/en/blackhole-storage-engine.html
The BLACKHOLE storage engine acts as a “black hole” that accepts data but throws it away and does not store it. To examine the source for the BLACKHOLE engine, look in the sql directory of a MySQL source distribution. When you create a ...
https://dev.mysql.com/doc/refman/8.4/en/built-in-function-reference.html
The following table lists each built-in (native) function and operator and provides a short description of each one. For a table listing functions that are loadable at runtime, see Section 14.2, “Loadable Function Reference”. ->> Return value ...
https://dev.mysql.com/doc/refman/8.4/en/c-api-info.html
The MySQL C API Developer Guide is published in standalone form, not as part of the MySQL Reference Manual.
https://dev.mysql.com/doc/refman/8.4/en/cannot-create.html
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 in the temporary directory: Can't create/write to file '\\sqla3fe_0.ism'. The preceding error is a typical message for ...
https://dev.mysql.com/doc/refman/8.4/en/cannot-find-table.html
Even for file systems that are not case-sensitive, such as on Windows, all references to a given table within a query must use the same lettercase. You can check which tables are in the default database with SHOW TABLES.
https://dev.mysql.com/doc/refman/8.4/en/changing-mysql-user.html
On Windows, you can run the server as a Windows service using a normal user account. On Linux, for installations performed using a MySQL repository or RPM packages, the MySQL server mysqld should be started by the local mysql operating system user.
https://dev.mysql.com/doc/refman/8.4/en/charset-collation-information-schema.html
String columns in INFORMATION_SCHEMA tables have a collation of utf8mb3_general_ci, which is case-insensitive. However, for values that correspond to objects that are represented in the file system, such as databases and tables, searches in ...
https://dev.mysql.com/doc/refman/8.4/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 ...
https://dev.mysql.com/doc/refman/8.4/en/charset-repertoire.html
The repertoire of a character set is the collection of characters in the set. String expressions have a repertoire attribute, which can have two values: ASCII: The expression can contain only ASCII characters; that is, characters in the Unicode ...