2 批处理模式下运行mysql
(1)把想要运行的mysql语句放在一个文本文件batch-file.txt中;
(2)执行:mysql -h host -u user -p < batch-file.txt;
(3)将输出重定向至文件out.txt:
mysql -h host -u user -p < batch-file.txt > out.txt;
从mysql提示符运行脚本:
mysql> source batch-file.txt;或者mysql> /. batch-file.txt;bitsCN.com