MySQL client

Syntax

• mysql [OPTIONS] [database_name]

Parameters

Parameter | Description ––––– | ——-D --database=name | name of the database--delimiter=str | set the statement delimiter. The default one is ‘;’-e --execute='command' | execute command-h --host=name | hostname to connect to-p --password=name| password Note: there is no space between -p and the password-p (without password) | the password will be prompted for-P --port=#| port number-s --silent| silent mode, produce less output. Use \t as column separator-ss | like -s, but omit column names-S --socket=path | specify the socket (Unix) or named pipe (Windows) to use when connecting to a local instance--skip-column-names | omit column names-u --user=name | username-U --safe-updates --i-am-a-dummy| login with the variable sql_safe_updates=ON. This will allow only DELETE and UPDATE that explicitly use keys-V --version | print the version and exit