Mysql command tool

Typing help at this prompt will display a list of the commands supported by the tool listed below. Commands are terminated by a semi-colon ;. If a command is not terminated by a semi-colon, pressing enter simply continues the current command on the following line.

Jump to: navigation , search. Navigation menu Personal tools. Namespaces Page Discussion. Views Read View source View history. Easy navigation between tabs. The software is very quick, and we ran into no lags or crashes.

Allows to save queries and name them for future use. Cons: Some database are not yet supported, so it can't be used as an all-in-one database IDE. Advanced database management capabilities such as restoring SQL dumps or data migration capabilities are not yet available. There is currently no plugins system supported, to no community enhancements are available. Free to download, licensed under GPL. In some cases, the entire application has to be killed.

Price: Free for basic usage. Visual schema and query builder. Cons: The software is sometimes buggy some users report software crashes. Price: Free. Portable version is available for download, so you can use it without administrative privileges, nor requiring installation.

Full database user management and privileges management options. Automate connections via command line utility. Great syntax checks and auto completion features. Send the current statement to the server to be executed and display the result using vertical format. Exit mysql.

Disable output paging. See the description for pager. Disable output copying to the tee file. See the description for tee. Enable output paging. By using the --pager option when you invoke mysql , it is possible to browse or search query results in interactive mode with Unix programs such as less , more , or any other similar program.

If you specify no value for the option, mysql checks the value of the PAGER environment variable and sets the pager to that. Pager functionality works only in interactive mode. Output paging can be enabled interactively with the pager command and disabled with nopager.

The command takes an optional argument; if given, the paging program is set to that. With no argument, the pager is set to the pager that was set on the command line, or stdout if no pager was specified. Output paging works only in Unix because it uses the popen function, which does not exist on Windows.

For Windows, the tee option can be used instead to save query output, although it is not as convenient as pager for browsing output in some situations. Reconfigure the mysql prompt to the given string.

The special character sequences that can be used in the prompt are described later in this section. Define query attributes that apply to the next query sent to the server. For discussion of the purpose and use of query attributes, see Section 9. The format and quoting rules for attribute names and values are the same as for the delimiter command.

Names and values may be up to characters long. If a name is given without a value, an error occurs. After sending the query, mysql clears the attribute set. If multiple attributes are defined with the same name, attempts to retrieve the attribute value have an undefined result. An attribute defined with an empty name cannot be retrieved by name. If a reconnect occurs while mysql executes the query, mysql restores the attributes after reconnecting so the query can be executed again with the same attributes.

Rebuild the completion hash that enables database, table, and column name completion while you are entering statements. See the description for the --auto-rehash option. Reset the connection to clear the session state.

This example shows how resetconnection clears a value maintained in the session state:. Read the named file and executes the statements contained therein. Quote characters are taken as part of the file name itself. For best results, the name should not include space characters.

Provide status information about the connection and the server you are using. If you are running with --safe-updates enabled, status also prints the values for the mysql variables that affect your queries. Prior to MySQL 8. As of 8. By using the --tee option when you invoke mysql , you can log statements and their output.

All the data displayed on the screen is appended into a given file.