PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/miscellaneous-functions.html
There are multiple ways to cause MySQL to accept the query: Alter the table to make name a primary key or a unique NOT NULL column. This may be useful if you simply do not care which value of a nonaggregated column is chosen for each group. The ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-options-variables.html
--ndb-default-column-format=[FIXED|DYNAMIC] Command-Line Format --ndb-default-column-format={FIXED|DYNAMIC} Introduced 5.7.11-ndb-7.5.1 System Variable ndb_default_column_format Scope Global Dynamic Yes Type Enumeration Default Value (≥ ... This ...
https://dev.mysql.com/doc/refman/5.7/en/numeric-type-attributes.html
This optional display width may be used by applications to display integer values having a width less than the width specified for the column by left-padding them with spaces. Whether it is used is up to the application.) The display width does not ... MySQL supports an extension for optionally specifying the display width of integer data types in parentheses following the base keyword for the ...
https://dev.mysql.com/doc/refman/5.7/en/union.html
Selected columns listed in corresponding positions of each SELECT statement should have the same data type. For example, the first column selected by the first statement should have the same type as the first column selected by the other statements.
https://dev.mysql.com/doc/refman/5.7/en/data-size.html
You can get better performance for a table and minimize storage space by using the techniques listed here: Table Columns Row Format Indexes Joins Normalization Table Columns Use the most efficient (smallest) data types possible. MEDIUMINT is often a ... Design your tables to minimize their space on the ...
https://dev.mysql.com/doc/refman/5.7/en/blob.html
They have the binary character set and collation, and comparison and sorting are based on the numeric values of the bytes in column values. If strict SQL mode is not enabled and you assign a value to a BLOB or TEXT column that exceeds the column's ... A BLOB is a binary large object that can hold a variable amount of ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-cjk.html
You can obtain this information for a column column_name in the table table_name using the following query: SELECT HEX(column_name) FROM table_name; 3F is the encoding for the ? character; this means that ? is the character actually stored in the ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-range.html
While the examples work as shown for purposes of the present discussion, you should keep in mind that tables are extremely likely in practice to have primary keys, unique keys, or both, and that allowable choices for partitioning columns depend on ... 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 ...
https://dev.mysql.com/doc/refman/5.7/en/view-updatability.html
However, if such a column is updated explicitly, the only permitted value is DEFAULT. For information about generated columns, see Section 13.1.18.7, “CREATE TABLE and Generated Columns”. Also, only a single table in the view definition can be ... Some views are updatable and references to them can be used to specify tables to be updated in data change ...
https://dev.mysql.com/doc/refman/5.7/en/char.html
The length of a CHAR column is fixed to the length that you declare when you create the table. The effective maximum length of a VARCHAR is subject to the maximum row size (65,535 bytes, which is shared among all columns) and the character set used.