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/replication-features-differing-tables.html
Between any of the string types CHAR, VARCHAR, and TEXT, including conversions between different widths. Lossy conversion is handled by inserting only the first N characters of the string on the replica, where N is the width of the target column.
https://dev.mysql.com/doc/refman/5.7/en/show-index.html
However, prefix lengths for index specifications in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements are interpreted as number of characters for nonbinary string types (CHAR, VARCHAR, TEXT) and number of bytes for binary string types (BINARY, ... SHOW {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr] SHOW INDEX returns table index ...
https://dev.mysql.com/doc/refman/5.7/en/x-plugin-options-system-variables.html
If X Plugin is enabled, it exposes several system variables that permit control over its operation: mysqlx_bind_address Command-Line Format --mysqlx-bind-address=addr Introduced 5.7.17 System Variable mysqlx_bind_address Scope Global Dynamic No Type ... To control activation of X Plugin, use this option: --mysqlx[=value] Command-Line Format --mysqlx[=value] Introduced 5.7.12 Type Enumeration Default Value ON Valid Values ONOFFFORCEFORCE_PLUS_PERMANENT This option controls how the server loads X Plugin at ...
https://dev.mysql.com/doc/refman/5.7/en/apis-perl.html
For ways to quote string literals, see Section 9.1.1, “String Literals”. The Perl DBI module provides a generic interface for database access. You can write a DBI script that works with many different database engines without change. To use DBI ...
https://dev.mysql.com/doc/refman/5.7/en/char.html
The following table illustrates the differences between CHAR and VARCHAR by showing the result of storing various string values into CHAR(4) and VARCHAR(4) columns (assuming that the column uses a single-byte character set such as latin1). The CHAR ...
https://dev.mysql.com/doc/refman/5.7/en/charset-errors.html
Character (nonbinary) string values are converted from their character set to UTF-8. Binary string values are copied as is for bytes in the range 0x20 to 0x7E, and using \x hexadecimal encoding for bytes outside that range. This section describes ...
https://dev.mysql.com/doc/refman/5.7/en/constraint-enum.html
The value cannot be the error value (that is, 0 or the empty string). A SET value must be the empty string or a value consisting only of the values listed in the column definition separated by commas. For SET, the value is inserted as given except ... ENUM and SET columns provide an efficient way to define columns that can contain only a given set of ...
https://dev.mysql.com/doc/refman/5.7/en/converting-tables-to-innodb.html
Rather than storing a customer or catalog item number as a string of digits, potentially using up several bytes, convert it to a numeric ID for storing and querying. If you have MyISAM tables that you want to convert to InnoDB for better ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-foreign-keys.html
For nonbinary (character) string columns, the character set and collation must be the same. MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data ...
https://dev.mysql.com/doc/refman/5.7/en/data-types.html
MySQL supports SQL data types in several categories: numeric types, date and time types, string (character and byte) types, spatial types, and the JSON data type. This chapter provides an overview and more detailed description of the properties of ...