Search Results
https://dev.mysql.com/doc/refman/8.4/en/charset-connection.html
Some of these have been mentioned in earlier sections: The character_set_server and collation_server system variables indicate the server character set and collation. Exception: For string literals that have an introducer such as _utf8mb4 or ... A ...
https://dev.mysql.com/doc/refman/8.4/en/charset-general.html
Suppose that we have an alphabet with four letters: A, B, a, b. But what if we want to say that the lowercase and uppercase letters are equivalent? Then we would have at least two rules: (1) treat the lowercase letters a and b as equivalent to A and ... A character set is a set of symbols and ...
https://dev.mysql.com/doc/refman/8.4/en/charset-mysql.html
Collations have these general characteristics: Two different character sets cannot have the same collation. The INFORMATION_SCHEMA COLLATIONS table and the SHOW COLLATION statement have a column that indicates for each collation whether it is the ...
https://dev.mysql.com/doc/refman/8.4/en/column-count-limit.html
You have to change some columns to TEXT or BLOBs mysql> CREATE TABLE t (a VARCHAR(10000), b VARCHAR(10000), c VARCHAR(10000), d VARCHAR(10000), e VARCHAR(10000), f VARCHAR(10000), g VARCHAR(6000)) ENGINE=MyISAM CHARACTER SET latin1; ERROR 1118 ...
https://dev.mysql.com/doc/refman/8.4/en/connection-control-plugin-installation.html
If the plugins have been previously registered with INSTALL PLUGIN or are loaded with --plugin-load-add, you can use the --connection-control and --connection-control-failed-login-attempts options at server startup to control plugin activation. The ... This section describes how to install the connection control plugins, CONNECTION_CONTROL and ...
https://dev.mysql.com/doc/refman/8.4/en/connection-interfaces.html
For example, a Windows server that does not have support for named-pipe connections enabled does not create a thread to handle them. To monitor the number of threads in the cache and how many threads have been created because a thread could not be ... This section describes aspects of how the MySQL server manages client ...
https://dev.mysql.com/doc/refman/8.4/en/create-temporary-table.html
To create a temporary table, you must have the CREATE TEMPORARY TABLES privilege. Suppose that the current user does not have the CREATE TEMPORARY TABLES privilege but is able to execute a definer-context stored procedure that executes with the ...
https://dev.mysql.com/doc/refman/8.4/en/creating-ssl-rsa-files-using-mysql.html
SSL and RSA File Characteristics SSL and RSA files created automatically by the server have these characteristics: SSL and RSA keys have a size of 2048 bits. SSL files have blank values for Country (C), State or Province (ST), Organization (O), ...
https://dev.mysql.com/doc/refman/8.4/en/data-size.html
(InnoDB compressed tables are readable and writable, while MyISAM compressed tables are read-only.) For MyISAM tables, if you do not have any variable-length columns (VARCHAR, TEXT, or BLOB columns), a fixed-size row format is used. You can hint ...
https://dev.mysql.com/doc/refman/8.4/en/database-use.html
Suppose that you have several pets in your home (your menagerie) and you would like to keep track of various types of information about them. The list of databases displayed by the statement may be different on your machine; SHOW DATABASES does not ... Once you know how to enter SQL statements, you are ready to access a ...