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/mysqldump-delimited-text.html
This section describes how to use mysqldump to create delimited-text dump files. For information about reloading such dump files, see Section 7.4.4, “Reloading Delimited-Text Format Backups”. If you invoke mysqldump with the --tab=dir_name ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlimport.html
--bind-address=ip_address Command-Line Format --bind-address=ip_address On a computer having multiple network interfaces, use this option to select which interface to use for connecting to the MySQL server. The mysqlimport client provides a ...
https://dev.mysql.com/doc/refman/5.7/en/operator-precedence.html
For example: mysql> SELECT 1+2*3; -> 7 mysql> SELECT (1+2)*3; -> 9 . Operator precedences are shown in the following list, from highest precedence to the lowest. Operators that are shown together on a line have the same precedence. When used as a ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-types.html
Similar to partitioning by RANGE, except that the partition is selected based on columns matching one of a set of discrete values. With this type of partitioning, a partition is selected based on the value returned by a user-defined expression that ... This section discusses the types of partitioning which are available in MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/password-management.html
Operations performed by a restricted client result in an error until the user establishes a new account password: mysql> SELECT 1; ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement. MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-file-summary-tables.html
Example file I/O event summary information: mysql> SELECT * FROM performance_schema.file_summary_by_event_name\G ... The Performance Schema maintains file I/O summary tables that aggregate information about I/O operations. row ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-instrument-filtering.html
The setup_instruments table lists the available instruments: mysql> SELECT * FROM performance_schema.setup_instruments; +---------------------------------------------------+---------+-------+ | NAME | ENABLED | TIMED | ...| stage/sql/end | NO | NO ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-instrument-naming.html
For example, the statement/sql/create_db and statement/sql/select instruments are used for CREATE DATABASE and SELECT statements. An instrument name consists of a sequence of elements separated by '/' characters. Example names: ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-prepared-statements-instances-table.html
For example, for the following SQL statement, the name of the prepared statement is stmt: PREPARE stmt FROM 'SELECT 1'; SQL_TEXT The prepared statement text, with ? placeholder markers. These columns can be used to find stored programs that leak ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-tables.html
By contrast, using the Performance Schema tables, information about replica status can be searched using general SELECT queries, including complex WHERE conditions, joins, and so forth. If needed, these values can be obtained from the process list ...This is similar to the information available from the SHOW SLAVE STATUS statement, but representation in table form is more accessible and has usability benefits: SHOW SLAVE STATUS output is useful for visual inspection, but not so much for programmatic ...