MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 991 to 1000 of 1137 total results

https://dev.mysql.com/doc/refman/5.7/en/counting-rows.html

The use of COUNT() in conjunction with GROUP BY is useful for characterizing your data under various groupings. Counting the total number of animals you have is the same question as “How many rows are in the pet table?” because there is one ...

4.6.6 mysql_config_editor — MySQL Configuration Utility

https://dev.mysql.com/doc/refman/5.7/en/mysql-config-editor.html

The unobfuscated format of the .mylogin.cnf login path file consists of option groups, similar to other option files. Each option group in .mylogin.cnf is called a “login path,” which is a group that permits only certain options: host, user, ...

4.5.1.1 mysql Client Options

https://dev.mysql.com/doc/refman/5.7/en/mysql-command-options.html

mysql supports the following options, which can be specified on the command line or in the [mysql] and [client] groups of an option file. --defaults-group-suffix=str Command-Line Format --defaults-group-suffix=str Type String Read not only the ...

4.4.7 mysql_upgrade — Check and Upgrade MySQL Tables

https://dev.mysql.com/doc/refman/5.7/en/mysql-upgrade.html

mysql_upgrade supports the following options, which can be specified on the command line or in the [mysql_upgrade] and [client] groups of an option file. --defaults-group-suffix=str Command-Line Format --defaults-group-suffix=str Type String Read ...

4.5.2 mysqladmin — A MySQL Server Administration Program

https://dev.mysql.com/doc/refman/5.7/en/mysqladmin.html

mysqladmin supports the following options, which can be specified on the command line or in the [mysqladmin] and [client] groups of an option file. --defaults-group-suffix=str Command-Line Format --defaults-group-suffix=str Type String Read not only ...You can use it to check the server's configuration and current status, to create and drop databases, and ...

4.5.3 mysqlcheck — A Table Maintenance Program

https://dev.mysql.com/doc/refman/5.7/en/mysqlcheck.html

Command Meaning mysqlrepair The default option is --repair mysqlanalyze The default option is --analyze mysqloptimize The default option is --optimize mysqlcheck supports the following options, which can be specified on the command line or in the ...

4.5.5 mysqlimport — A Data Import Program

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 ...

4.5.6 mysqlpump — A Database Backup Program

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 ...

4.5.7 mysqlshow — Display Database, Table, and Column Information

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 ...

4.5.8 mysqlslap — A Load Emulation Client

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, ...

Displaying 991 to 1000 of 1137 total results