MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 971 to 980 of 1125 total results

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

An XA transaction progresses through the following states: Use XA START to start an XA transaction and put it in the ACTIVE state. For an ACTIVE XA transaction, issue the SQL statements that make up the transaction, and then issue an XA END ...

3.3.4.8 Counting Rows

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

Displaying 971 to 980 of 1125 total results