Home Database Mysql Tutorial 使用Mysql命令行工具执行sql脚本时的小问题_MySQL

使用Mysql命令行工具执行sql脚本时的小问题_MySQL

Jun 01, 2016 pm 01:31 PM
download computer

bitsCN.com

使用Mysql命令行工具执行sql脚本时的小问题

 

在执行sql脚本时本来是按照语法来的

 

source create.sql(create.sql文件的完全路径)
Copy after login

我在自己的电脑上输入的是

1source f:/download/create.sql;
Copy after login

但是输入完成后没有执行任何结果,也没有报错,后来在网上查了,有同学说是"/"的原因,要使用"/",或者要进行转义"//",我依次试过后,发现还是不行,而且报出了failed to open file ... 最后我无意中再输入了一次

1source f:/create.sql
Copy after login

 

 

为了方便,我把文件直接放在了F盘根目录下,这次竟然成功了,原来是多了一个分号的原因。

 

bitsCN.com
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot Article Tags

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

How to type fraction symbols on the computer (easy and fast method to input fraction symbols) How to type fraction symbols on the computer (easy and fast method to input fraction symbols) May 04, 2024 pm 12:01 PM

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? 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? Jun 09, 2024 pm 08:58 PM

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?

How to fine-tune deepseek locally How to fine-tune deepseek locally Feb 19, 2025 pm 05:21 PM

How to fine-tune deepseek locally

The easiest way to mirror your phone screen to your computer (one step to easily project your phone screen to your computer) The easiest way to mirror your phone screen to your computer (one step to easily project your phone screen to your computer) May 09, 2024 pm 07:13 PM

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 Desktop icon disappears and needs to be redisplayed or resized? Introduction to quick solutions Jun 02, 2024 pm 10:37 PM

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

deepseek image generation tutorial deepseek image generation tutorial Feb 19, 2025 pm 04:15 PM

deepseek image generation tutorial

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? 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? Jun 25, 2024 pm 04:59 PM

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 How to turn off location services in Win10? Tips for turning off the positioning system on your computer Jun 07, 2024 pm 04:02 PM

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

See all articles