https://dev.mysql.com/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/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/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/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, UDFs, or plugins. For a list of SQL functions ...
https://dev.mysql.com/control-flow-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/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 utf8 COLLATE utf8_unicode_ci ) CHARACTER SET latin1 ...
https://dev.mysql.com/partitioning-columns-range.html
Range columns partitioning is similar to range partitioning, but enables you to define partitions using ranges based on multiple column values. In addition, you can define the ranges using columns of types other than integer types. RANGE COLUMNS ...
https://dev.mysql.com/fulltext-stopwords.html
The stopword table must have a single VARCHAR column named value. The stopword list is loaded and searched for full-text queries using the server character set and collation (the values of the character_set_server and collation_server system ...
https://dev.mysql.com/partitioning-hash.html
Partitioning by HASH is used primarily to ensure an even distribution of data among a predetermined number of partitions. To partition a table using HASH partitioning, it is necessary to append to the CREATE TABLE statement a PARTITION BY HASH ...
https://dev.mysql.com/partitioning-list.html
List partitioning in MySQL is similar to range partitioning in many ways. As in partitioning by RANGE, each partition must be explicitly defined. The chief difference between the two types of partitioning is that, in list partitioning, each ...
