您好，我已经从 oracle 网站安装了 MySQL，但在程序菜单中的 MySQL 下没有找到“MySQL 命令行”选项。
所以我在这个网站上查找了如何从 DOS 命令提示符执行 sql 查询。
我在此网站上找到了一个答案，建议输入以下内容：sql root u- p- 等，但这不起作用。
谁能告诉我从 DOS 进入 sql 的语法，或者指导我找到上面描述的答案（我找不到它）
我使用 Windows 7 并下载了 ODBC 驱动程序。
非常感谢。
Hi I have installed MySQL from oracle website, but did not get a "MySQL Command Line" option under MySQL in Programs menu.
So I looked up on this site how to execute sql queries from DOS command prompt.
I found an answer on this site that advised to type in something like: sql root u- p- etc. but this does not work.
Can anyone advise me the syntax to use to go into sql from DOS, or direct me to the answer described above (I cannot locate it)
I use Windows 7 and downloaded the ODBC driver, too.
Many thanks.
发布评论
评论（4）
除非 MySQL 的 bin 目录位于您的 PATH 变量中，否则您需要位于该目录中，或者写入其绝对路径才能执行。
尝试这样的操作（取决于您的安装）：
或者，您可以直接输入：
Unless MySQL's bin directory is in your
PATHvariable, you will need to either be in the directory, or write an absolute path to it to execute.Try something like this (depending on your installation):
Alternatively, you could type this directly:
在这行代码之后你有这个
欢迎信息告诉你 mysql 的服务器版本和你的连接 ID
after this line of codes you have this
welcome note telling you the server version of mysql and your connection id
如果您导航到刚刚安装的程序的 bin 目录，然后输入“mysql.exe”，
请查看 此指南
If you navigate to the bin directory of the program you just installed then type "mysql.exe"
Have a look at this guide if you get stuck with the commands
确定MySQL安装路径，并将其添加到
PATH环境变量中。上面的示例假设 MySQL 安装在 C:\MySQL 目录中。
设置好路径后，就可以直接执行
以root用户登录MySQL了。如果需要密码，可以使用
-p标志。每次都需要执行
SET PATH，因此您可以制作一个批处理文件。Determine the path of your MySQL installation, and add it to
PATHenvironment variable.The above example assumes MySQL to be installed in C:\MySQL directory.
Once path is set, then you can directly execute
Which logs into MySQL as root user. The
-pflag can be used if password is requiredIt is required to execute
SET PATHevery time, hence you may make a batch file.