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/use.html
This statement requires some privilege for the database or some object within it. USE db_name The USE statement tells MySQL to use the named database as the default (current) database for subsequent statements. The named database remains the ...
https://dev.mysql.com/doc/refman/5.7/en/version-tokens.html
This is a signal to the application that it should seek a different server in the required state to receive the SQL statement. MySQL includes Version Tokens, a feature that enables creation of and synchronization around server tokens that ...
https://dev.mysql.com/doc/refman/5.7/en/view-check-option.html
Before MySQL 5.7.6, WITH CHECK OPTION testing works like this: With LOCAL, the view WHERE clause is checked, but no underlying views are checked. The WITH CHECK OPTION clause can be given for an updatable view to prevent inserts to rows for which ...
https://dev.mysql.com/doc/refman/5.7/en/windows-select-server.html
It is necessary to enable this variable explicitly because some users have experienced problems with shutting down the MySQL server when named pipes were used. The following table shows the available servers for Windows in MySQL 5.7. Binary ...
https://dev.mysql.com/doc/refman/5.7/en/windows-testing.html
In this case, start mysqld with the skip_name_resolve system variable enabled and use only localhost and IP addresses in the Host column of the MySQL grant tables. (Be sure that an account exists that specifies an IP address or you may not be able ...
https://dev.mysql.com/doc/refman/5.7/en/x-plugin-option-variable-reference.html
This table provides an overview of the command options, system variables, and status variables provided by X Plugin.
https://dev.mysql.com/doc/refman/5.7/en/x-plugin.html
This section explains how to configure and monitor the X Plugin.
https://dev.mysql.com/doc/refman/5.7/en/xa-states.html
An XA RECOVER statement at this point includes the transaction's xid value in its output, because XA RECOVER lists all XA transactions that are in the PREPARED state. An XA transaction progresses through the following states: Use XA START to start ...
https://dev.mysql.com/doc/refman/5.7/en/zlib-decompress.html
Invoke zlib_decompress like this: zlib_decompress input_file output_file Example: mysqlpump --compress-output=ZLIB > dump.zlib zlib_decompress dump.zlib dump.txt To see a help message, invoke zlib_decompress with no arguments. The zlib_decompress ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table.html
This is a MySQL extension to standard SQL, which permits only one of each clause per ALTER TABLE statement. For example, to drop multiple columns in a single statement, do this: ALTER TABLE t2 DROP COLUMN c, DROP COLUMN d; If a storage engine does ... ALTER TABLE tbl_name [alter_option [, alter_option] ...] [partition_options] alter_option: { table_options | ADD [COLUMN] col_name column_definition [FIRST | AFTER col_name] | ADD [COLUMN] (col_name column_definition,...) | ADD {INDEX | KEY} [index_name] [index_type] (key_part,...) [index_option] ...