DATABASE » SQL » MYSQL

Command

Last updated:

Usage

bash

mysql OPTIONS DBNAME

Option	Description
`-h` `--host`	Connect to the MySQL server on the given host.
`-P` `--port`	The TCP/IP port number to use for the connection.
`-u` `--user`	The MySQL user name to use when connecting to the server.
`-p` `--password`	The password to use when connecting to the server.
`-e` `--execute`	Execute the given SQL query and exit.
`-t` `--table`	Display output in table format.
`-N` `--skip-column-names`	Don't write column names in results.
`-s` `--silent`	Output in tab separated format.