PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/type-conversion.html
mysql> SELECT 1+'1'; -> 2 mysql> SELECT CONCAT(2,' test'); -> '2 test' It is also possible to convert a number to a string explicitly using the CAST() function. Conversion occurs implicitly with the CONCAT() function because it expects string ...For ... When an operator is used with operands of different types, type conversion occurs to make the operands ...
https://dev.mysql.com/doc/refman/5.7/en/glossary.html
An API provides a stable set of names and types for functions, procedures, parameters, and return values. client libraries Files containing collections of functions for working with databases. client-side prepared statement A type of prepared ...
https://dev.mysql.com/doc/refman/5.7/en/charset-binary-collations.html
This section describes how the binary collation for binary strings compares to _bin collations for nonbinary strings. Binary strings (as stored using the BINARY, VARBINARY, and BLOB data types) have a character set and collation named binary. A ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-command-options.html
--binary-as-hex when enabled affects display of all binary strings, including those returned by functions such as CHAR() and UNHEX(). By default, mysql translates \r\n in statement strings to \n and interprets \0 as the statement terminator. mysql ...
https://dev.mysql.com/doc/refman/5.7/en/sys-format-statement.html
Given a string (normally representing an SQL statement), reduces it to the length given by the statement_truncate_len configuration option, and returns the result. Otherwise, the middle part of the string is replaced by an ellipsis (...). This ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking-usage.html
General-Purpose Masking Functions mask_inner() and mask_outer() are general-purpose functions that mask parts of arbitrary strings based on position within the string: mask_inner() masks the interior of its string argument, leaving the ends unmasked. Converting the value to a binary string ensures that the function sees an argument of length ...To use MySQL Enterprise Data Masking and De-Identification ... Before using MySQL Enterprise Data Masking and ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-import.html
ndb_import requires a connection to an NDB management server (ndb_mgmd) to function; it does not require a connection to a MySQL Server. Higher values reduce status printing exponentially up to some pre-defined limit ADDED: NDB 7.6.2 ... ndb_import ...
https://dev.mysql.com/doc/refman/5.7/en/charset-introducer.html
A character string literal, hexadecimal literal, or bit-value literal may have an optional character set introducer and COLLATE clause, to designate it as a string that uses a particular character set and collation: [_charset_name] literal [COLLATE ...Escapes are always interpreted by the parser according to the character set given by ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlimport.html
--character-sets-dir=dir_name Command-Line Format --character-sets-dir=path Type String Default Value [none] The directory where character sets are installed. --debug[=debug_options], -# [debug_options] Command-Line Format --debug[=debug_options] ...
https://dev.mysql.com/doc/refman/5.7/en/enum.html
An ENUM is a string object with a value chosen from a list of permitted values that are enumerated explicitly in the column specification at table creation time. See Section 11.3.1, “String Data Type Syntax” for ENUM type syntax and length ...