-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathscript.sh
9 lines (8 loc) · 1.51 KB
/
script.sh
1
2
3
4
5
6
7
8
9
#!/bin/bash
for i in $(mysql -h $DATABASE_HOST -u $MYSQL_USER -p$MYSQL_PASSWORD -e "show databases;" | grep "\|" | grep -v information_schema | grep -v Database)
do
COMMAND="call $i.$PROCEDURE();"
TEST="mysql -h $DATABASE_HOST -u $MYSQL_USER -p$MYSQL_PASSWORD -e \"$COMMAND\""
eval $TEST
echo $TEST
done