MySQL MySQL client

Help us to keep this website almost Ad Free! It takes only 10 seconds of your time:
> Step 1: Go view our video on YouTube: EF Core Bulk Insert
> Step 2: And Like the video. BONUS: You can also share it!

Syntax

  • mysql [OPTIONS] [database_name]

Parameters

ParameterDescription
-D --database=namename of the database
--delimiter=strset the statement delimiter. The default one is ';'
-e --execute='command'execute command
-h --host=namehostname to connect to
-p --password=namepassword Note: there is no space between -p and the password
-p (without password)the password will be prompted for
-P --port=#port number
-s --silentsilent mode, produce less output. Use \t as column separator
-sslike -s, but omit column names
-S --socket=pathspecify the socket (Unix) or named pipe (Windows) to use when connecting to a local instance
--skip-column-namesomit column names
-u --user=nameusername
-U --safe-updates --i-am-a-dummylogin with the variable sql_safe_updates=ON. This will allow only DELETE and UPDATE that explicitly use keys
-V --versionprint the version and exit


Got any MySQL Question?