PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/optimize-numeric.html
For unique IDs or other values that can be represented as either strings or numbers, prefer numeric columns to string columns. Since large numeric values can be stored in fewer bytes than the corresponding strings, it is faster and takes less ...If ...
https://dev.mysql.com/doc/refman/5.7/en/option-file-options.html
--defaults-group-suffix=str Command-Line Format --defaults-group-suffix=string Type String Default Value [none] Read not only the usual option groups, but also groups with the usual names and a suffix of str. --login-path=name Command-Line Format ...
https://dev.mysql.com/doc/refman/5.7/en/problems-with-alias.html
In the select list of a query, a quoted column alias can be specified using identifier or string quoting characters: SELECT 1 AS `one`, 2 AS 'two'; Elsewhere in the statement, quoted references to the alias must use identifier quoting or the ... An ...
https://dev.mysql.com/doc/refman/5.7/en/secure-client-programming.html
If the user enters extra information, it all becomes part of the string. In a numeric context, MySQL automatically converts this string to a number and strips any trailing nonnumeric characters from it. If the older ext/mysql extension must be used, ... Client applications that access MySQL should use the following guidelines to avoid interpreting external data incorrectly or exposing sensitive ...
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/year.html
YEAR accepts input values in a variety of formats: As 4-digit strings in the range '1901' to '2155'. As 1- or 2-digit strings in the range '0' to '99'. To insert zero and have it be interpreted as 2000, specify it as a string '0' or '00'. In strict ... The YEAR type is a 1-byte type used to represent year ...
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/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 ...
https://dev.mysql.com/doc/refman/5.7/en/federated-usagenotes.html
When using a CONNECTION string, you cannot use an '@' character in the password. The following items indicate features that the FEDERATED storage engine does and does not support: The remote server must be a MySQL server. The remote table that a ...