Home >Database >Mysql Tutorial >mysql下怎样运行脚本以运行niuzi.sql为例_MySQL
mysql下怎样运行脚本以运行niuzi.sql为例_MySQL
- WBOYOriginal
- 2016-06-01 13:05:221126browse
假设要运行脚本： F:\hello world\niuzi.sql
第一种方法:
在命令行下(未连接数据库),输入 mysql -h localhost -u root -p
第二种方法:
在命令行下(已连接数据库,此时的提示符为 mysql> ),输入 source F:\hello world\niuzi.sql (注意路径不用加引号的) 或者 \. F:\hello world\niuzi.sql (注意路径不用加引号的)
Statement：
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
Previous article：MYSQL IN 与 EXISTS 的优化示例介绍_MySQLNext article：MySql事务无法回滚的原因有哪些_MySQL