Search Results
https://dev.mysql.com/doc/connector-j/en/connector-j-reference-type-conversions.html
The conversions that are always guaranteed to work are listed in the following table. The values returned by ResultSetMetaData.GetColumnTypeName()and ResultSetMetaData.GetColumnClassName() are shown in the table below. MySQL Connector/J is flexible ...
https://dev.mysql.com/doc/refman/8.4/en/account-management-statements.html
MySQL account information is stored in the tables of the mysql system schema. Important Some MySQL releases introduce changes to the grant tables to add new privileges or features. To make sure that you can take advantage of any new capabilities, ...This database and the access control system are discussed extensively in Chapter 7, MySQL Server Administration, which you should consult for additional ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-transaction-compression.html
Note You can enable binary logging of compressed transactions for tables using the NDB storage engine at run time using the ndb_log_transaction_compression system variable, and control the level of compression using ... MySQL supports binary log ...
https://dev.mysql.com/doc/refman/8.4/en/charset-metadata.html
This is also true of the contents of tables in INFORMATION_SCHEMA because those tables by definition contain information about database objects. Otherwise, neither the SHOW statements nor SELECT statements for tables in INFORMATION_SCHEMA would work ... Metadata is “the data about the data.” Anything that describes the database—as opposed to being the contents of the database—is ...
https://dev.mysql.com/doc/refman/8.4/en/charset-mysql.html
To display the available character sets, use the INFORMATION_SCHEMA CHARACTER_SETS table or the SHOW CHARACTER SET statement. To list the display collations for a character set, use the INFORMATION_SCHEMA COLLATIONS table or the SHOW COLLATION ...
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 ...
https://dev.mysql.com/doc/refman/8.4/en/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 ...
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode.html
MySQL 8.4 also displays utf8mb3 in place of utf8 in the columns of Information Schema tables, and in the output of SQL SHOW statements. Table 12.2, “Unicode Character Set General Characteristics”, summarizes the general characteristics of ...
https://dev.mysql.com/doc/refman/8.4/en/comparisons-using-subqueries.html
It finds all rows in table t1 containing a value that occurs twice in a given column: SELECT * FROM t1 AS t WHERE 2 = (SELECT COUNT(*) FROM t1 WHERE t1.id = t.id); For a comparison of the subquery to a scalar, the subquery must return a scalar. The ...
https://dev.mysql.com/doc/refman/8.4/en/constant-folding-optimization.html
Consider the table created by the following statement: CREATE TABLE t (c TINYINT UNSIGNED NOT NULL); The WHERE condition in the query SELECT * FROM t WHERE c < 256 contains the integral constant 256 which is out of range for a TINYINT UNSIGNED ...