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/mysqlimport.html
mysqlimport supports the following options, which can be specified on the command line or in the [mysqlimport] and [client] groups of an option file. --defaults-group-suffix=str Command-Line Format --defaults-group-suffix=str Type String Read not ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlpump.html
mysqlpump Option Summary mysqlpump supports the following options, which can be specified on the command line or in the [mysqlpump] and [client] groups of an option file. (Prior to MySQL 5.7.30, mysqlpump read the [mysql_dump] group rather than ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlshow.html
mysqlshow supports the following options, which can be specified on the command line or in the [mysqlshow] and [client] groups of an option file. --defaults-group-suffix=str Command-Line Format --defaults-group-suffix=str Type String Read not only ... The mysqlshow client can be used to quickly see which databases exist, their tables, or a table's columns or ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlslap.html
Run all the load statements, then run all the queries in the query file with five clients (five times each): mysqlslap --concurrency=5 --iterations=5 --query=query.sql --create=create.sql --delimiter=";" mysqlslap supports the following options, ...
https://dev.mysql.com/doc/refman/5.7/en/option-file-options.html
--defaults-group-suffix=str Command-Line Format --defaults-group-suffix=string Type String Default Value [none] Read not only the usual option groups, but also groups with the usual names and a suffix of str. For example, the mysql client normally ... Most MySQL programs that support option files handle the following ...
https://dev.mysql.com/doc/refman/5.7/en/derived-tables.html
This does not work: SELECT AVG(SUM(column1)) FROM t1 GROUP BY column1; However, this query provides the desired information: SELECT AVG(sum_column1) FROM (SELECT SUM(column1) AS sum_column1 FROM t1 GROUP BY column1) AS t1; Notice that the column ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tp-thread-state-table.html
The TP_THREAD_STATE table has these columns: TP_GROUP_ID The thread group ID. TP_GROUP_ID and TP_THREAD_NUMBER together provide a unique key within the table. The xxx_WAIT columns of the TP_THREAD_GROUP_STATS table accumulate counts for each wait ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-online-add-node-example.html
In this section we provide a detailed example illustrating how to add new NDB Cluster data nodes online, starting with an NDB Cluster having 2 data nodes in a single node group and concluding with a cluster having 4 data nodes in 2 node groups. You ...This make it easier later to assign node IDs that are not already in use to data nodes which are newly ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-installer-workflow.html
The group must be established on Windows before you can select it from the list. Windows requires a newly added member to first log out and then log in again to join a local group. In the Windows Security Tokens area, enter a token for each Windows ... MySQL Installer provides a wizard-like tool to install and configure new MySQL products for ...
https://dev.mysql.com/doc/refman/5.7/en/calculating-days.html
The following example shows how you can use the bit group functions to calculate the number of days per month a user has visited a Web page. CREATE TABLE t1 (year YEAR, month INT UNSIGNED, day INT UNSIGNED); INSERT INTO t1 ...