實驗如下: [root@idb1 ~]# more /etc/issue CentOS release 6.5 (Final) Kernel /r on an /m
mysql> show variables like 'version'; +---------------+------------+ | Variable_name | Value | +---------------+------------+ | version | 5.6.27-log | +---------------+------------+ 1 row in set (0.00 sec)
[root@idb1 ~]# sh shell_example01.sh Warning: Using a password on the command line interface can be insecure. Logging to file '/tmp/temp.log' +------+-------+ | id | val | +------+-------+ | 1 | jack | | 2 | robin | | 3 | mark | +------+-------+ Outfile disabled.
2、 shell腳本中MySQL提示符下調用SQL命令例子: [root@idb1 ~]# cat shell_example02.sh #!/bin/bash mysql -umdba -pdsf0723 <<EOF source /root/temp.sql; select current_date(); delete from tempdb.tb_tmp where id=3; select * from tempdb.tb_tmp where id=2; EOF exit
[root@idb1 ~]# sh shell_example02.sh Warning: Using a password on the command line interface can be insecure. Logging to file '/tmp/temp.log' id val 1 duansf 2 liuyb 3 jack Outfile disabled. current_date() 2017-03-14 id val 2 liuyb
