mysql is a simple SQL shell with input line editing capabilities. It supports interactive and noninteractive use. When used interactively, query results are presented in an ASCII-table format. When used noninteractively (for example, as a filter), the result is …

mysql sends each SQL statement that you issue to the server to be executed. There is also a set of commands that mysql itself interprets. For a list of these commands, type help or \h at the mysql> prompt:

Shell Commands - provides details about the available built-in MySQL Shell commands. ShellAPI - contains information about the shell and util global objects, as well as the mysql module that enables executing SQL on MySQL Servers. SQL Syntax - entry point to retrieve syntax help on SQL statements.

This document describes the core features of MySQL Shell. In addition to the provided SQL functionality, similar to mysql, MySQL Shell provides scripting capabilities for JavaScript and Python and includes APIs for working with MySQL.

Aug 2, 2022 · This section describes use of command-line options to specify how to establish connections to the MySQL server, for clients such as mysql or mysqldump.

The MySQL Shell is an interactive Javascript, Python, or SQL interface supporting development and administration for the MySQL Server and is a component of the MySQL Server. You can use the MySQL Shell to perform data queries and updates as well as various administration operations. Traditional Table, JSON, Tab Separated output results formats

The mysqlshow client can be used to quickly see which databases exist, their tables, or a table's columns or indexes. mysqlshow provides a command-line interface to several SQL SHOW statements. See Section 15.7.7, “SHOW Statements”. The same information can be obtained by using those statements directly.

On Windows, click Start, All Programs, MySQL, MySQL 5.7 Command Line Client (or MySQL 8.0 Command Line Client, respectively). If you did not install MySQL with the MySQL Installer, open a command prompt, go to the bin folder under the base directory of your MySQL installation, and issue the following command:

Shell Commands - provides details about the available built-in MySQL Shell commands. ShellAPI - contains information about the shell and util global objects, as well as the mysql module that enables executing SQL on MySQL Servers. SQL Syntax - entry point to retrieve syntax help on SQL statements.

This section provides an overview of the command-line integration and some basic usage examples. For more detailed information, see Section 5.8.2, “Command Line Integration Details”.