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/using-date.html
To be on the safe side, assume that strings are compared as strings and use the appropriate string functions if you want to compare a temporal value to a string. MySQL also permits a “relaxed” string format when updating and in a WHERE clause ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-natural-language.html
By default or with the IN NATURAL LANGUAGE MODE modifier, the MATCH() function performs a natural language search for a string against a text collection. For each row in the table, MATCH() returns a relevance value; that is, a similarity measure ...
https://dev.mysql.com/doc/refman/5.7/en/known-issues.html
In MIN(), MAX(), and other aggregate functions, MySQL currently compares ENUM and SET columns by their string value rather than by the string's relative position in the set. Even if you use lower_case_table_names=2 (which enables MySQL to remember ... This section lists known issues in recent versions of ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-replica.html
--replicate-do-db=db_name Command-Line Format --replicate-do-db=name Type String Creates a replication filter using the name of a database. --replicate-ignore-db=db_name Command-Line Format --replicate-ignore-db=name Type String Creates a ... This ...
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/firewall-usage.html
These may invoke administrative functions, so stored procedure access also requires the privileges needed for those functions. Grant the SUPER privilege so that the firewall administrative functions can be executed. Warning Setting the ... Before ...
https://dev.mysql.com/doc/refman/5.7/en/sql-prepared-statements.html
For example, the C API provides a set of function calls that make up its prepared statement API. For example, you cannot use the mysql_stmt_prepare() C API function to prepare a PREPARE, EXECUTE, or DEALLOCATE PREPARE statement. SQL syntax for ...
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/date-and-time-types.html
To convert strings in other orders to year-month-day order, the STR_TO_DATE() function may be useful. For descriptions of functions that operate on temporal values, see Section 12.7, “Date and Time Functions”. However, with dates such as these, ... The date and time data types for representing temporal values are DATE, TIME, DATETIME, TIMESTAMP, and ...