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/date-and-time-type-syntax.html
MySQL displays DATE values in 'YYYY-MM-DD' format, but permits assignment of values to DATE columns using either strings or numbers. MySQL displays DATETIME values in 'YYYY-MM-DD hh:mm:ss[.fraction]' format, but permits assignment of values to ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-mgm-client-commands.html
CONNECT connection-string Connects to the management server indicated by the connection string. PROMPT [prompt] Changes the prompt shown by ndb_mgm to the string literal prompt. mgm#1: PROMPT mymgm > mymgm > PROMPT 'mymgm:' 'mymgm:' PROMPT mymgm: ...
https://dev.mysql.com/doc/refman/5.7/en/select.html
} export_options: [{FIELDS | COLUMNS} [TERMINATED BY 'string'] [[OPTIONALLY] ENCLOSED BY 'char'] [ESCAPED BY 'char'] ] [LINES [STARTING BY 'string'] [TERMINATED BY 'string'] ] SELECT is used to retrieve rows selected from one or more tables, and can ... SELECT [ALL | DISTINCT | DISTINCTROW ] [HIGH_PRIORITY] [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT] [SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS] select_expr [, select_expr] ...
https://dev.mysql.com/doc/refman/5.7/en/character-arrays.html
For a complex character set as implemented in a ctype-MYSET.c file in the strings directory, there are corresponding arrays: ctype_MYSET[], to_lower_MYSET[], and so forth. See the CHARSET_INFO.txt file in the strings directory for additional ...
https://dev.mysql.com/doc/refman/5.7/en/charset-gb18030.html
Supports comparison between gb18030 strings, and between gb18030 strings and strings of other character sets. In MySQL, the gb18030 character set corresponds to the “Chinese National Standard GB 18030-2005: Information technology — Chinese ...
https://dev.mysql.com/doc/refman/5.7/en/error-message-elements.html
Error Message Elements When an error occurs, error information includes several elements: an error code, SQLSTATE value, and message string. SQLSTATE value: This value is a five-character string (for example, '42S02'). Message string: This string ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-boolean.html
With this modifier, certain characters have special meaning at the beginning or end of words in the search string. Specify the search words within a double-quoted string immediately before the @distance operator, for example, MATCH(col1) ... MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/identifiers.html
mysql> SET sql_mode='ANSI_QUOTES'; mysql> CREATE TABLE "test" (col INT); Query OK, 0 rows affected (0.00 sec) The ANSI_QUOTES mode causes the server to interpret double-quoted strings as identifiers. Consequently, when this mode is enabled, string ... Certain objects within MySQL, including database, table, index, column, alias, view, stored procedure, partition, tablespace, and other object names are known as ...
https://dev.mysql.com/doc/refman/5.7/en/index-btree-hash.html
The index also can be used for LIKE comparisons if the argument to LIKE is a constant string that does not start with a wildcard character. LIKE '%string%' and string is longer than three characters, MySQL uses the Turbo Boyer-Moore algorithm to ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-columns-table.html
The COLUMNS table has these columns: TABLE_CATALOG The name of the catalog to which the table containing the column belongs. TABLE_SCHEMA The name of the schema (database) to which the table containing the column belongs. ORDINAL_POSITION is ...