Search Results
https://dev.mysql.com/doc/relnotes/connector-odbc/en/news-8-0-24.html
(WL #14426) Bugs Fixed Setting PAD_SPACE=1 did not cause CHAR columns to be padded with spaces to their full length, which prevented the MSSQL linked server from working with ENUM and CHAR columns in the MySQL Database. (Bug #32079486) ... Security ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-bulk-load-mysql-server.html
Table 4.1 Supported Data Types for Bulk Ingest Data Type Available MySQL version Comments INT All SMALLINT All TINYINT All BIGINT All CHAR All BINARY All VARCHAR All Before MySQL 9.0.0, the record must fit in the page as there is no large data ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-data-load-prerequisites.html
To save space in memory, set CHAR, VARCHAR, and TEXT type column lengths to the minimum length required for the longest string value. Apply dictionary encoding to CHAR, VARCHAR, and TEXT columns whenever appropriate. This topic describes how to ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table.html
You can also change characteristics such as the storage engine used for the table or the table comment. Use of table options with ALTER TABLE provides a convenient way of altering single table characteristics. To change the default table character ... ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ADD [COLUMN] (col_name column_definition,...) | ADD {INDEX | KEY} [index_name] [index_type] (key_part,...) [index_option] ...
https://dev.mysql.com/doc/refman/8.4/en/charset-collation-effect.html
latin1_swedish_ci latin1_german1_ci latin1_german2_ci Muffler Muffler Müller MX Systems Müller Muffler Müller MX Systems MX Systems MySQL MySQL MySQL The character that causes the different sort orders in this example is ü (German ...The first ...
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/create-procedure.html
The COLLATE attribute can be used if preceded by a CHARACTER SET specification. The COMMENT characteristic is a MySQL extension, and may be used to describe the stored routine. The LANGUAGE characteristic indicates the language in which the routine ...By default, a stored routine is associated with the default ...
https://dev.mysql.com/doc/refman/8.4/en/explain.html
There is no need to enclose the string within quotation marks unless it contains spaces or other special characters. In practice, the DESCRIBE keyword is more often used to obtain information about table structure, whereas EXPLAIN is used to obtain ...
https://dev.mysql.com/doc/refman/8.4/en/load-data.html
Input File Character Set The file name must be given as a literal string. The server interprets the file name using the character set indicated by the character_set_filesystem system variable. By default, the server interprets the file contents ...
https://dev.mysql.com/doc/refman/8.4/en/locking-service.html
The locking interface has these characteristics: Locks have three attributes: Lock namespace, lock name, and lock mode: Locks are identified by the combination of namespace and lock name. Namespace and lock names must be non-NULL, nonempty, and have ... MySQL distributions provide a locking interface that is accessible at two levels: At the SQL level, as a set of loadable functions that each map onto calls to the service ...