PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/charset-national.html
Standard SQL defines NCHAR or NATIONAL CHAR as a way to indicate that a CHAR column should use some predefined character set. For example, these data type declarations are equivalent: CHAR(10) CHARACTER SET utf8 NATIONAL CHARACTER(10) NCHAR(10) As ...Please consider using CHAR(x) CHARACTER SET UTF8MB4 in order to be ...
https://dev.mysql.com/doc/refman/8.0/en/string-type-syntax.html
[NATIONAL] CHAR[(M)] [CHARACTER SET charset_name] [COLLATE collation_name] A fixed-length string that is always right-padded with spaces to the specified length when stored. NATIONAL CHAR (or its equivalent short form, NCHAR) is the standard SQL way ... The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and ...
https://dev.mysql.com/doc/refman/8.0/en/char.html
The CHAR and VARCHAR types are similar, but differ in the way they are stored and retrieved. They also differ in maximum length and in whether trailing spaces are retained. The CHAR and VARCHAR types are declared with a length that indicates the ...
https://dev.mysql.com/doc/refman/8.0/en/column-count-limit.html
This section describes limits on the number of columns in tables and the size of individual rows. Column Count Limits Row Size Limits Column Count Limits MySQL has hard limit of 4096 columns per table, but the effective maximum may be less for a ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations.html
This section discusses current restrictions and limitations on MySQL partitioning support. The following constructs are not permitted in partitioning expressions: Stored procedures, stored functions, loadable functions, or plugins. For a list of ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-range.html
A table that is partitioned by range is partitioned in such a way that each partition contains rows for which the partitioning expression value lies within a given range. Ranges should be contiguous but not overlapping, and are defined using the ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-component-functions.html
mask_iban(str [, mask_char]) Masks an International Bank Account Number (IBAN) and returns the number with all but the first two letters (denoting the country) replaced by '*' characters. Each country can have a different national routing or account ...mask_canada_sin(str [, mask_char]) Masks a Canada Social Insurance Number (SIN) and returns the number with all meaningful digits replaced by 'X' ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-operations.html
Online support details, syntax examples, and usage notes for DDL operations are provided under the following topics in this section. Index Operations Primary Key Operations Column Operations Generated Column Operations Foreign Key Operations Table ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-columns-list.html
This is a variant of LIST partitioning that enables the use of multiple columns as partition keys, and for columns of data types other than integer types to be used as partitioning columns; you can use string types, DATE, and DATETIME columns. In ...
https://dev.mysql.com/doc/refman/8.0/en/cast-functions.html
NCHAR[(N)] Like CHAR, but produces a string with the national character set. spatial_type As of MySQL 8.0.24, CAST() and CONVERT() support casting geometry values from one spatial type to another, for certain combinations of spatial types. Cast ...