shell脚本循环操作多个mysql数据库
#!/bin/bash
mysql="mysql -uroot -proot"
arr=(swoole test3 test2)
for db in ${arr[*]}
do
$mysql -e "insert into ${db}.test(username, create_time) values('hihi', RAND()*8)" 2>/dev/null
done
#!/bin/bash
mysql="mysql -uroot -proot"
arr=(swoole test3 test2)
for db in ${arr[*]}
do
$mysql -e "insert into ${db}.test(username, create_time) values('hihi', RAND()*8)" 2>/dev/null
done