Home >Database >Mysql Tutorial >mysql和oracle批处理运行sql文件和oracle导入dmp文件_MySQL
mysql和oracle批处理运行sql文件和oracle导入dmp文件_MySQL
- WBOYOriginal
- 2016-06-01 13:38:481352browse
bitsCN.com
mysql和oracle批处理运行sql文件和oracle导入dmp文件
mysql批处理运行sql：
net stop mysql
net start mysql
echo Wscript.Sleep(3000) > sleep.vbs
start /w wscript.exe sleep.vbs
del /Q sleep.vbs
mysql -f -u mysql -ppassword anxiesoft
net stop mysql
net start mysql
pause;
oracle批处理运行sql：
sqlplus dssc/dssc@dssc @./update.sql > ./update.log
oracle导入dmp文件：
imp dssc/dssc@dssc file=d:/0713.dmp tables=(organization,devices ) log=d:/imp0713.log ignore=y
pause
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：重复项过滤+排序的解决办法_MySQLNext article：mysql中查询前10条记录_MySQL