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