PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/data-masking-component-usage.html
Thus, even though ssn is defined as VARCHAR(11), if the ssn column has a multibyte character set, it may appear to be longer than 11 bytes when passed to a loadable function, and returns NULL while logging the error. Before using MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-row-format.html
Tables that use the REDUNDANT row format store the first 768 bytes of variable-length column values (VARCHAR, VARBINARY, and BLOB and TEXT types) in the index record within the B-tree node, with the remainder stored on overflow pages. Tables that ...
https://dev.mysql.com/doc/refman/8.0/en/local-variable-scope.html
The scope of a local variable is the BEGIN ... The variable can be referred to in blocks nested within the declaring block, except those blocks that declare a variable with the same name. Because local variables are in scope only during stored ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-handling-nulls.html
Partitioning in MySQL does nothing to disallow NULL as the value of a partitioning expression, whether it is a column value or the value of a user-supplied expression. Even though it is permitted to use NULL as the value of an expression that must ...
https://dev.mysql.com/doc/refman/8.0/en/explain-output.html
In this context, VARCHAR and CHAR are considered the same if they are declared as the same size. To fix this disparity between column lengths, use ALTER TABLE to lengthen ActualPC from 10 characters to 15 characters: mysql> ALTER TABLE tt MODIFY ...
https://dev.mysql.com/doc/refman/8.0/en/flow-control-functions.html
If all types are character string (CHAR or VARCHAR), the result is VARCHAR with maximum length determined by the longest character length of the operands. SET and ENUM are treated similar to VARCHAR; the result is VARCHAR. The second syntax returns ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-storage-engine.html
MyISAM also supports the following features: Support for a true VARCHAR type; a VARCHAR column starts with a length stored in one or two bytes. Tables with VARCHAR columns may have fixed or dynamic row length. The sum of the lengths of the VARCHAR ... MyISAM is based on the older (and no longer available) ISAM storage engine but has many useful ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html
The TempTable storage engine provides efficient storage for VARCHAR and VARBINARY columns. String types that are cast include CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. This section summarizes what has been added to, deprecated ...
https://dev.mysql.com/doc/refman/8.0/en/blob.html
Similarly, you can regard a TEXT column as a VARCHAR column. BLOB and TEXT differ from VARBINARY and VARCHAR in the following ways: For indexes on BLOB and TEXT columns, you must specify an index prefix length. MySQL Connector/ODBC defines BLOB ...
https://dev.mysql.com/doc/refman/8.0/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 ...