PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-host-cache-table.html
The host_cache table has these columns: IP The IP address of the client that connected to the server, expressed as a string. HOST The resolved DNS host name for that client IP, or NULL if the name is unknown. The MySQL server maintains an in-memory ...
https://dev.mysql.com/doc/refman/5.7/en/start-slave.html
The option cannot be set to an empty or null string. START SLAVE [thread_types] [until_option] [connection_options] [channel_option] thread_types: [thread_type [, thread_type] ... ] thread_type: IO_THREAD | SQL_THREAD until_option: UNTIL { ...
https://dev.mysql.com/doc/refman/5.7/en/federated-create.html
You can either create the local table and specify the connection string (containing the server name, login, password) to be used to connect to the remote table using the CONNECTION, or you can use an existing connection that you have previously ...
https://dev.mysql.com/doc/refman/5.7/en/bit-value-literals.html
For example, a bit literal assigned to a user-defined variable is a binary string by default. A leading 0b is case-sensitive and cannot be written as 0B. In numeric contexts, MySQL treats a bit literal like an integer. To ensure numeric treatment of ...
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-information-schema.html
String columns in INFORMATION_SCHEMA tables have a collation of utf8_general_ci, which is case-insensitive. However, for values that correspond to objects that are represented in the file system, such as databases and tables, searches in ...For ...
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/mysql-cluster-params-ndbd.html
Note that string '/BACKUP' is always appended to this setting, so that *effective* default is FileSystemPath/BACKUP. StringMemory: Default size of string memory (0 to 100 = % of maximum, 101+ = actual bytes). Default is empty string; see ... The ...
https://dev.mysql.com/doc/refman/5.7/en/generated-column-index-optimizations.html
row *************************** id: 1 select_type: SIMPLE table: t1 partitions: NULL type: range possible_keys: gc key: gc key_len: 5 ref: NULL rows: 1 filtered: 100.00 Extra: Using index condition In effect, the optimizer has replaced the ...For ...
https://dev.mysql.com/doc/refman/5.7/en/extensions-to-ansi.html
RENAME and let the server rename the files.) General language syntax By default, strings can be enclosed by " as well as '. If the ANSI_QUOTES SQL mode is enabled, strings can be enclosed only by ' and the server interprets strings enclosed by " as ... MySQL Server supports some extensions that are likely not to be found in other SQL ...
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-implementations.html
Example: "U+0000 NULL" does not have a weight and is ignorable. mysql> SET NAMES 'utf8' COLLATE 'utf8_unicode_ci'; Query OK, 0 rows affected (0.05 sec) mysql> SELECT HEX('a'), HEX(WEIGHT_STRING('a')); +----------+-------------------------+ | ...