如何在Windows10命令提示符下在mysql中正确执行sql文件？

lpwwtiir  于 2021-06-18  发布在  Mysql
关注(0)|答案(2)|浏览(423)

我已经试了将近三十分钟，试图找出如何从win10命令提示符执行sql文件，但我仍然不知道如何做到这一点。
我在mysql>目录中，在文件路径之前，我不知道“source”是什么。在mysql文件的路径之前，我需要输入什么“source”？
下面是我试图执行的bookorama.sql文件的路径：c:\wamp64\bin\mysql\mysql5.7.23\bin
bookorama.sql位于最后一个“bin”文件夹的文件路径中。
到目前为止，我一直在努力寻找答案，但在这些帖子中，我一直在尝试很多关于答案的建议，但我仍然没有找到正确的答案。
无法从命令提示符运行mysql
执行sql文件
如何在mysql中使用命令行导入sql文件？
使用命令行执行.sql文件
https://tecadmin.net/run-sql-text-file-on-mysql-command-prompt/
下面是试图执行sql文件的命令提示符的副本：

  1. C:\wamp64\bin\mysql\mysql5.7.23\bin>mysql -hlocalhost -uroot -p
  2. Enter password:*********
  3. Welcome to the MySQL monitor.  Commands end with ; or \g.
  4. Your MySQL connection id is 22
  5. Server version: 5.7.23 MySQL Community Server (GPL)
  7. Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
  9. Oracle is a registered trademark of Oracle Corporation and/or its
  10. affiliates. Other names may be trademarks of their respective
  11. owners.
  13. Type 'help;' or '\h' for help. Type '\c' to clear the current input 
  15. mysql> use books
  16. Database changed
  17. mysql> -u bookorama -d books < bookoroma.sql
  18.     -> ;
  19. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual 
  20. that corresponds to your MySQL server version for the right syntax to use 
  21. near '-u bookorama -d books < bookoroma.sql' at line 1
  22. mysql> mysql
  23.     -> ;
  24. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual 
  25. that corresponds to your MySQL server version for the right syntax to use 
  26. near 'mysql' at line 1
  27. mysql> mysql -h localhost - u bookorama -p < bookorama.sql
  28.     -> ;
  29. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual 
  30. that corresponds to your MySQL server version for the right syntax to use 
  31. near 'mysql -h localhost - u bookorama -p < bookorama.sql' at line 1
  32. mysql> cd..
  33.     -> ;
  34. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual 
  35. that corresponds to your MySQL server version for the right syntax to use 
  36. near 'cd..' at line 1
  37. mysql> mysql -h localhost -u bookorama -D books -p < bookorama.sql
  38.     ->
  39.     -> CREATE TABLE Customers
  40.     -> ;
  41. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual 
  42. that corresponds to your MySQL server version for the right syntax to use 
  43. near 'mysql -h localhost -u bookorama -D books -p < bookorama.sql
  45. CREATE TABLE Custom' at line 1
  46. mysql> -u bookorama -D books -P < bookorama.sql
  47.     -> ;
  48. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual 
  49. that corresponds to your MySQL server version for the right syntax to use 
  50. near '-u bookorama -D books -P < bookorama.sql' at line 1mysql> -u root
  51.     -> -p Oscar545* -D bookorama < bookorama.sql
  52.     -> ;
  53. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual 
  54. that corresponds to your MySQL server version for the right syntax to use 
  55. near '-u root
  56. -p Oscar545* -D bookorama < bookorama.sql' at line 1
  57. mysql> mysql -h localhose u-root -D bookorama < 
  58. C:\wamp64\bin\mysql\mysql5.7.23\bin.bookorama.sql
  59. Show warnings disabled.
  60. ERROR:
  61. Unknown command '\b'.
  62. ERROR:
  63. Unknown command '\m'.
  64. ERROR:
  65. Unknown command '\m'.
  66. ERROR:
  67. Unknown command '\b'.
  68.     -> ;
  69. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual 
  70. that corresponds to your MySQL server version for the right syntax to use 
  71. near 'mysql -h localhose u-root -D bookorama < 
  72. C:amp64\bin\mysql\mysql5.7.23\bin.booko' at line 1
  73. mysql> mysql -h localhose u-root -D bookorama < bookorama.sql
  74.     -> ;
  75. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual 
  76. that corresponds to your MySQL server version for the right syntax to use 
  77. near 'mysql -h localhose u-root -D bookorama < bookorama.sql' at line 1
  78. mysql> mysql -u root -p books < bookorama.sql
  79.     -> ;
  80. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual 
  81. that corresponds to your MySQL server version for the right syntax to use 
  82. near 'mysql -u root -p books < bookorama.sql' at line 1
  83. mysql> use books
  84. Database changed
  85. mysql> mysql -u root -p books < bookorama.sql
  86.     -> ;
  87. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual 
  88. that corresponds to your MySQL server version for the right syntax to use 
  89. near 'mysql -u root -p books < bookorama.sql' at line 1
  90. mysql> C:\wamp64\bin\mysql\mysql5.7.23\bin bookorama.sql
  91. Show warnings disabled.ERROR:
  92. Unknown command '\b'.
  93. ERROR:
  94. Unknown command '\m'.
  95. ERROR:
  96. Unknown command '\m'.
  97. ERROR:
  98. Unknown command '\b'.
  99.     -> ;
  100. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual 
  101. that corresponds to your MySQL server version for the right syntax to use 
  102. near 'C:amp64\bin\mysql\mysql5.7.23\bin bookorama.sql' at line 1
  103. mysql> source C:\wamp64\bin\mysql\mysql5.7.23\bin;
  104. Show warnings disabled.
  105. ERROR:
  106. Unknown command '\b'.
  107. ERROR:
  108. Unknown command '\m'.
  109. ERROR:
  110. Unknown command '\m'.
  111. ERROR:
  112. Unknown command '\b'.
  113. ERROR:
  114. Failed to open file 'C:amp64\bin\mysql\mysql5.7.23\bin', error: 2
  115. mysql> C:\wamp64\bin\mysql\mysql5.7.23\bin\bookorama.sql
  116. Show warnings disabled.
  117. ERROR:
  118. Unknown command '\b'.
  119. ERROR:
  120. Unknown command '\m'.
  121. ERROR:
  122. Unknown command '\m'.
  123. ERROR:
  124. Unknown command '\b'.
  125. ERROR:
  126. Unknown command '\b'.
  127.     -> ;
  128. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual 
  129. that corresponds to your MySQL server version for the right syntax to use 
  130. near 'C:amp64\bin\mysql\mysql5.7.23\bin\bookorama.sql' at line 1
  131. mysql> mysql -h localhost -u root
  132.     -> ;
  133. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual 
  134. that corresponds to your MySQL server version for the right syntax to use 
  135. near 'mysql -h localhost -u root' at line 1
  136. mysql> -h localhost -root -pOscar545* books < bookorama.sql
  137.     -> ;
  138. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual 
  139. that corresponds to your MySQL server version for the right syntax to use 
  140. near '-h localhost -root -pOscar545* books < bookorama.sql' at line 1
  141. mysql> mysql -u root -p books < bookorama.sql
  142.     -> ;
  143. ERROR 1064 (42000): You have an error in your SQL syntax; check the manual 
  144. that corresponds to your MySQL server version for the right syntax to use 
  145. near 'mysql -u root -p books < bookorama.sql' at line 1
  146. mysql>
sqlmysqlwindows-10command-prompt

2条答案

按热度按时间
ifmq2ha2

ifmq2ha21#

在 mysql> 提示您使用：

  1. use books;
  2. source bookorama.sql;

在命令提示下，您将使用：

  1. mysql.exe -h localhost -root -pOscar545* books < bookorama.sql
赞(0）分享  回复(0）举报  2021-06-18
gopyfrb3

gopyfrb32#

mysql cli（命令行界面）与其他cli或shell程序一样，包括数据库（postgres的psql、sqlite的sqlite3、sql server的sqlcmd、oracle的sqlplus）、langauges（python.exe、perl.exe、php.exe、r.exe），还有一些是可执行文件（.exe），它们不像大多数软件.exe那样使用gui启动，而是在终端窗口中调用会话。
命令行解释器，如windows的powershell和cmd.exe，或unix的（macos/linux）bash终端，用于启动这样的cli会话。实际上，有两种方法可以运行mysql命令：
呼叫 mysql.exe 有争论而不开庭。
启动mysql会话并运行单独的调用。
您的问题是上述两种情况的合并，您正在尝试对 mysql.exe 里面有参数 mysql.exe 或者在会话中运行其顶级参数。在cli中，解析器只解释特殊的mysql命令，比如 source 以及不可执行的直接sql查询， mysql ，调用或连接参数( -h, -u )没有shell命令调用程序： \! .
只需在cli会话之外使用适当的调用：

  1. cd C:\amp64\bin\mysql\mysql5.7.23\bin
  2. mysql -h localhost -u bookorama -p < bookorama.sql

或在cli会话中：

  1. cd C:\amp64\bin\mysql\mysql5.7.23\bin
  2. mysql -h localhost -u bookorama -p
  3. mysql> source bookorama.sql

话虽如此，你却可以做相反的事。
在外部运行命令查询：

  1. mysql -h localhost -u bookorama -p -e "source bookorama.sql"

呼叫终端呼叫内部：

  1. mysql> \! mysql -h localhost -u bookorama -pXXXXX < bookorama.sql
展开查看全部
赞(0）分享  回复(0）举报  2021-06-18
我来回答

相关问题

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新问答

    更多
    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com