使用Mysql命令行工具执行sql脚本时的小问题_MySQL
Jun 01, 2016 pm 01:31 PMbitsCN.com
使用Mysql命令行工具执行sql脚本时的小问题
在执行sql脚本时本来是按照语法来的
source create.sql(create.sql文件的完全路径)
我在自己的电脑上输入的是
1source f:/download/create.sql;
但是输入完成后没有执行任何结果,也没有报错,后来在网上查了,有同学说是"/"的原因,要使用"/",或者要进行转义"//",我依次试过后,发现还是不行,而且报出了failed to open file ... 最后我无意中再输入了一次
1source f:/create.sql
为了方便,我把文件直接放在了F盘根目录下,这次竟然成功了,原来是多了一个分号的原因。
bitsCN.com

Hot Article

Hot tools Tags

Hot Article

Hot Article Tags

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

How to type fraction symbols on the computer (easy and fast method to input fraction symbols)

What should I do if my win11 wallpaper is locked and cannot be changed? What to do if my computer wallpaper is locked and cannot be changed?

The easiest way to mirror your phone screen to your computer (one step to easily project your phone screen to your computer)

Desktop icon disappears and needs to be redisplayed or resized? Introduction to quick solutions

What should I do if my Win10 password does not meet the password policy requirements? What to do if my computer password does not meet the policy requirements?

How to turn off location services in Win10? Tips for turning off the positioning system on your computer
